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)?
No, not really the comparison is not between stores, is between periods of the same stores. Data can be displayed store by store or multiple stores at the same time but data must be evalueted just in case the store has available data during the 12 months of the periods, if there are just 11 months available, then the store should be romeved of the aggregated result