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!