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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count unique distinct values that meet multiple criteria 1
Current month and the next two 1
Formula to fill cells based on Date of Arrival and Date of Departure 1
help with formula to calculate what column to use 1
Calculated Field on PT data shown as '% of Column' 4
Sub Totals as a calculated field in a pivot table 2
need some basic help 4
Custom Roll up and Drill down calculation for Excel Pivot table 2

Back
Top