D
Debra Dalgleish
You can remove the Grand Total for rows, if you don't want to see it:
Right-click on a cell in the pivot table, and click on Table Options
Remove the check mark from Grand Totals for Rows, click OK
If you want to focus on the years, remove the Quarters and Months from
the pivot table layout.
Then, add another copy of the quantities field to the data area
Set it to show Difference From, based on (previous)
Right-click on a cell in the pivot table, and click on Table Options
Remove the check mark from Grand Totals for Rows, click OK
If you want to focus on the years, remove the Quarters and Months from
the pivot table layout.
Then, add another copy of the quantities field to the data area
Set it to show Difference From, based on (previous)