Pivot Table - Additional Aggregated Column

deerio — Tue, 12 Sep 2023 16:31:31 GMT

Hi,

I have a pivot table that contains data calculated as:

I was able to obtain the column total, Total YTD, and the row total, Total, through the Show Total button (See Attachment 1).

Now, I need to add two more "Aggregated columns" to the pivot table:

Total YTD previous year, which calculates the sum of the measure for the entire previous year.
% Variations (Y2-Y1), which calculates the percentage difference between the total of Y1 and the total of Y2 (See Attachment 2).

Thanks in advance!

topic Pivot Table - Additional Aggregated Column in App Development