Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Where are you trying to do this? If this is in chart, do you have customer as your dimension?
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.