Turnover from customers who are growing

[Anonymous]

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)

[sunny_talwar]

Where are you trying to do this? If this is in chart, do you have customer as your dimension?

[Anonymous]

I'm trying to do this in table.

And yes, Customer Name is one of the dimensions.

I started wondering if it's even possible to display sales in way I described in the first post.