How do I select only the latest months in the year?
In my cross-table, I created a computation to cumulatively sum each month. I want to only show/plot the figures for the latest months in the year (not necessarily December since the latest month in 2025 is June). How would I accomplish this? 
0
Comments
Hi Simon
I'm guessing that maybe you have hidden the months in your example?
Anyway I did an example looking like this:
The last month is calculated like this: sum(d1, d-1(s), m1)
d-1(s) means the first "sibling" from the bottom.
The months are siblings since they belong to the same your - and therefore the last sibling will be the last month.
Hope it makes sense :-)
br/Niels
I see, that makes sense! Thank you for your assistance
Please sign in to leave a comment.