2 Replies Latest reply: Jul 12, 2016 10:17 AM by Pyry Kukkonen RSS

    Turnover from customers who are growing

    Pyry Kukkonen

      I was asked to make an expression which calculates sales from customers who are growing compared to last year (and for the ones who are dropping as well).

      I have already a expression which compares the results from Current Year to Last Year (see below) . How should I proceed from this?

       

      Sum(salesprice)-Sum({<[Calendar.Year]= {"$(=max([Calendar.Year])-1)"}>}salesprice)