Calculations in PivotTables

Hello, I hope you are well.
I'm working with PivotTable and I need to add one more row/category where it's the sum of certain rows/categories, also the total of the previous column and the cumulative total.

I'm working with the following fields: week, class, type, and sales. Where:

-week in column

  • class in lines
  • sales as values

So I need the previous week's Total, the week-to-week cumulative Total.

Thank you!

You will need to calculate that first before applying the pivot

1 Like

Obrigado @TonyC !
Funcionou.