Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am trying to create a linechart. Based on the date that the user chooses, I need to display the current rolling 12 months and previous rolling 12 months. This also means I need a dynamic x-axis.
Right now I only have
Rangeavg(Above(sum(Sales), 0, 12))
Which should be the current rolling 12 months for the sum of sales.
Any ideas?
PFA, there just isn't any sales data in there though
can't help if there is no data
Ok I'm not able to put that in. Thanks anyways!