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

Grey wrote:
> 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??

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html