Trying to put together an aggr expression.
If I want to consider previous month and I have a Calendar set up, why doesn't
I guess the other way to put it is: would you kindly give me an idea of the syntax for your aggr function given:
sales1 = tot sales selected month
sales2 = tot sales (selected month - 1)
Thanks in advance.
I've tried your expression, but unfortunately it's not returning any value...
So I've changed it to:
but it doesn't work either. If I insert a text box with
the value returned is the month before the one I selected, which is right. I just need to have that as my modifier...