Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Problem inserting calculated pivot fields into Pivot Table (2007) | Excel Discussion (Misc queries) | |||
Pivot table - Problem with % | Excel Discussion (Misc queries) | |||
Pivot table problem | Excel Worksheet Functions | |||
Pivot Table in Excel 2007 : Problem with % in Table | Excel Discussion (Misc queries) | |||
Pivot Table Problem | New Users to Excel |