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: 5
Default Pivot table - Problem with %

I have a question about pivot tables and percentages to which I did not
manage to find an answer till now. Hope someone can help me.

I need a pivot table with following information :
all customers that ordered in 2007 and 2008
amount of their turnover
Sofar no problem for the pivot table.

But now : I would like to get the difference between the turnover in 2007
and 2008 for each customer in %.
The row lines are Customer, the data 'calendar year' with the 2 years I need
selected.

Hope my question is clear... If not, please ask.

Can somebody help me ?

Many thanks in advance
The result should be that I get a pivot with a list of all custom
Row field = customer name

--
Ann, Flanders, Belgium
 
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
Pivot Table Problem John Calder New Users to Excel 4 March 29th 08 02:24 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 Siv Excel Discussion (Misc queries) 0 December 13th 05 07:59 AM
Pivot table problem Ross Excel Discussion (Misc queries) 1 November 24th 05 05:07 PM
Pivot Table Problem Yandros Excel Worksheet Functions 1 November 25th 04 12:52 PM


All times are GMT +1. The time now is 12:58 AM.

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

About Us

"It's about Microsoft Excel"