How to compare % difference between date range through pivot table

**ramkichn** · 05-09-2014, 08:55 AM

Hi All,

I would like to compare % difference between date range through pivot table

Date Range Product Amt
1st week ABC 1000
2nd Week ABC 2000
3rd Week ABC 1259
1st week XYZ 3000
2nd Week XYZ 4000
3rd Week XYZ 2500

How to plot a Pivot table to compare the % difference between 3rd Week Vs 2nd Week Vs 1 Week for each product through pivot table? Requesting this forum member support for the solution

Thanks
Ramki

**BrownBoy** · 05-09-2014, 09:10 AM

Here you go. Once your data is formatted in a proper data series then create your piovtTable. Put the proper fields in the appropriate row and column labels, add the product field to the values area.

Right click (while having the PT selected) > "Show values as" > % Of.. > Base field will be "Week" and base item will be "Previous".

percentChg.xlsx

If this works please add to my "rep". Let me know.

**BrownBoy** · 05-09-2014, 09:12 AM

Just noticed you're using Excel 2003. Try this version:

percentChg.xls

How to compare % difference between date range through pivot table

LinkBack

Thread Tools

Rate This Thread

Display

How to compare % difference between date range through pivot table

Re: How to compare % difference between date range through pivot table

Re: How to compare % difference between date range through pivot table

Thread Information

Users Browsing this Thread

Similar Threads

sumifs on a pivot table - compare range with range

Pivot Table filter by a date range inlcuding items with no data inisde that range only

Pivot Table Chart - Selecting Date Ranges and then Displaying Start/End of Date Range

Calculate Date difference in pivot table

[SOLVED] Pivot Table Date Range

Bookmarks

Bookmarks

Posting Permissions