Pivot table - Problem with %
Ann,
Right click "Sum of Turnover", select Field Settings..., then click Options, and choose Show data
as "% difference from" and choose the date as the base field, and 2007 as the base item.
HTH,
Bernie
MS Excel MVP
"Ann in Belgium" wrote in message
...
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
|