Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I've been having difficulty trying to write an expression that will look at the month at hand, and the 12 months before when performing a calculation.
I know about the ABOVE function, but it isn't behaving as we expect because the sheet is designed in a way that the user needs to select 3/4 months. I have tried using set analysis, but haven't succeeded.
Can anyone point me in the right direction / advise as to how I can achieve this?
Thanks very much in advance
Have you tried this?
Calculating rolling n-period totals, averages or other aggregations
See this example:
Hi Enrique
Thank you for your reply. The user is going to select 3/4 months. For example, February, March and April for one year and I'd like to see 3 different values for each month. Currently, how your expression functions, it will only show the result for the largest selected YEARMONTH.
Any suggestions to make this a little more flexible?
Thanks in advance!
Hi Arjun
Thanks for this. I am still a little bit stuck.
Essentially, the straight table will display the 3 months the user has selected. The dimension will be month.
Each of the months displayed will need to contain data from previous months (up to 12 months back).
Is this possible?