Hello. I got this pivot table, as you see I have several dimensions and about 7 measures, filtered by year.
I just want to get the YoY analysis. The user can filter how many years to compare, then you see the total sales from each year and then I want to see the % of variation from the year before.
I have tried aggr, above, year-1, etc, etc, but couldn´t make it work. It just filters the year from the filter or makes nonsense values.
I hope someone had the same problem.
Thank you in advance.