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?
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?