Forum Discussion
Solved
Filter groups base on group age
Hi!, I'm currently calculating %variation of last 12 month' sales of shopping centers and comparing it with same period last year (e.g. sales may2023-june2022 vs may2022- june2021... may2021- jun...
I solved this problem using parallelperiods combined with ALL and a variable table using SUMMARIZED.
In the case you are commenting, you want to evaluate the segment where there is data, that is, if a store opened in May-current vs one that opened in January of last year if you compare January-current (of last year) vs the new store you want Do you only have the segment of data it has (the history it has accumulated)?
I solved this problem using parallelperiods combined with ALL and a variable table using SUMMARIZED.