It's possible to do this by set analysis but it is easier, when you load data, to compute foe each month end other columns related to the rolleng period you desire for instance column1: start of the first rolling period, column2: end of the first rolling period.
In this way you can easily use set analysis simply comparing date
Hope it helps
Hi Alexandros. Thanks, this was very helpful. I have found some good examples using a AsOf table to achieve similar results, but i prefer the idea of using two columns to bound the start and the end of the rolling periods I need. I am working with three year rolling periods, and to generate all the date combinations for these sounds onerous.
Please could you elaborate a little on how your approach would work?
Yes, that's possible with three expressions. Something like:
Add those to a straight table, don't add any dimensions and check the option Horizontal on the Presentation tab.
Thanks for the suggestion Gysbert. I did manage to get this working and it worked well, but I think i may need to go down the pre-computed in the script route. The reason being, that really i need to combine the three seperate expressions into a single one; I have more expressions to build into the same table table which complicate things a little, especially when the table is made horizontal.