View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
George George is offline
external usenet poster
 
Posts: 347
Default Pivot table problem

Dear friends,

I have a list in an Excel 2007 spreadsheet:

Column A: Month (eg.Jan. 2007, Feb. 2007, Jan. 2008, Feb. 2008 €“ actually is
a date field and formatted to show only Month and Year)

ColumnB: Quantity (of sold products, eg. 2059, 1507, 2770, 1996 etc)
I have already inserted a pivot table which shows in first column the Month,
and then following columns are the years, e.g. 2007, 2008 and under each year
shows a value-quantity, using the Running totals. This works fine.

I want now to create another pivot table in order to show me the running
difference % between years/months e.g. using the above example to show me:

1. Percent difference between Jan. 2007 and Jan. 2008
2. Percent difference between Feb. 2008 and Feb. 2008 €“ Both using the
running totals

Any help will be highly appreciated,

Thanking you in advance

GeorgeCY