LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem inserting calculated pivot fields into Pivot Table (2007) wamiller36 Excel Discussion (Misc queries) 1 March 5th 10 11:40 PM
Pivot table - Problem with % Ann in Belgium Excel Discussion (Misc queries) 5 May 5th 09 12:26 PM
Pivot table problem Gemz Excel Worksheet Functions 2 February 27th 08 09:10 AM
Pivot Table in Excel 2007 : Problem with % in Table spudsnruf Excel Discussion (Misc queries) 2 January 9th 08 09:53 PM
Pivot Table Problem John Calder New Users to Excel 13 January 25th 07 12:37 AM


All times are GMT +1. The time now is 02:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright 2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"