Calculate the % increase for two columns

  • Thread starter Thread starter Grey
  • Start date Start date
G

Grey

I have a pivot table, the data was first display by date, i know i can use
the grouping function to group data into monthly basis. But I want to know
that can I set the formula to calculate the months difference between, say
the sales amount of June & July, and the % of the difference??


Million thanks
 
If you have a grouped field, you won't be able to add a calculated item
to the pivot table. In the source data, you could add a column to
calculate the month for each record.

Refresh the pivot table, and add the new field
Add another copy of the Data field to the data area
Right-click on one of its headings
Choose Field Settings
Click Option
Type a name for the field, e.g. %Diff
Choose to Show Data as % Difference From
As the Base Field, choose the new field
As the Base item, choose (previous)
Click OK
 
Back
Top