• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pivot Table - Creating Total Sales difference between years

L

lwilt

Member
I have a pivot table with the sales of 100 different products over a ten year period. The sales for each year are in a different column in the table that's being used so that when I make the pivot table I can put 2010 vs 2011 next to each other. Now is there anyway to create a column next to those two to show what the sales difference is between the two years? I'd like to be able to compare different years of data for the 100 products while being able to filter the data to look at different criteria. Is there a way for this the way I have the data set up or is there a better way to have the data that the pivot table is pulling from to be able to create this?

thanks.
 
I know there's a way to create a calculated value in a pivot table but I can't remember how to do it or if my data for the pivot table is set up correctly for this.
 
Hi,

Try the following Steps :

Once you have Pivot plotted, goto "PivotTable Tools" >> "Options".

Then click on "Formulas", "Calculated Field".
In the dialog box provide a name for the new field (for e.g. Diff. In years)
In the formula field enter : = 2011 (select from the Fields list) - 2010 (again select from the Fields list)
Click Add >> Ok.
You will see a new field showing the difference.

Hope this helps..
If it does not help, please provide the sheet.
 
You must log in or register to reply here.
Back
Top