Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm trying to create a combo chart which shows the % annual growth of sales (like the blue line in the image).
The values on data points aren't that important, my question is how can I make this line.
I tryed use set analysis with current year - current year-1 but doesn't worked.
My idea is to use a Dimension Group with Year and Month to show the variance when the user interact with the chart.
Hi,
Try with this:
(sum(Field) - Above(sum(Field))) / Above(Sum(Field))
Above() function gets the previous value.
Regards,
Ricardo
Use:
=sum(Sales)/above(sum(Sales))-1