Pivot Table - Compare Dates & calc. %

K

Kathy - Lovullo

Is there a way in a Pivot table to compare 2 time frames, calculate the $
Amount of Change between these to dates, and then sort by the $ Amount of
Change.

I have figured out how to compare the 2 dates and was able to calculate the
the change outside of the pivot table, but then I can not sort this in
descending order.

I think this calucation may need to be inside the pivot table to sort by it,
but I do not know how to create the calculated field to compare the same data
from one year against the same data from the next year.

Company 2008 Sales 2009 Sales $ change

ABC co 1000 1500 500
DEF co. 6000 6050 50
XZY Co. 5000 4500 -450
 

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

Pivot Table Comparison 0
Sort Pivot by Year 8
Pivot table, IF function, calculated item versus calculated field 1
Excel 2007 pivot table: select multiple data easier 0
Pivot Table Sort 0
Pivot Table Data Column Sort Excel 2007 1
sorting dates in a pivot table 1
Pivot Table Help 0

Top