Pivot Table - Additional Aggregated Column

[deerio]

Hi,

I have a pivot table that contains data calculated as:

• Sum(measure),
• Grouped by month (in the columns), and
• Grouped by category (in the rows).

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:

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

Thanks in advance!

1

2