Paul has attended:
Excel Advanced course
Pivottable
How do you use the % feature within pivot tables. Eg you have Sales, Budget, Variance and you want to know what the % Variance is. How is this possible?
RE: pivottable
Hi Paul
Thank you for your question.
If you double-click on the field you wish to display as a %, then click Options. This will extend the pivot table field dialogue box where you will have a show data as dropdown that you can choose from.
I hope this helps.
Amanda
RE: pivottable
Hmm...
I have the following on screen:
Actual - Target - B/W
I want a % B/W against Target.
When I get the field properties on screen, there is not an option to display as a % that I can understand in the above context. It refers to "Show Data as:", and the only one near logical is "% of". When you select this it then asks for the "Base Field", no problem, but then "Base Item"?????
Can you please be more speicific.
Many thanks in advance.
Paul
RE: pivottable
Hi Paul
Sorry for the delay in replying, I've been out of the office for a few days.
Have you been able to find a solution this week or still having problems?
If you're still battling with the spreadsheet, it would be useful if you could tell me what field/s you have this information in within the pivot table - I'm assuming they're all in the data items area but of course could be wrong. Do you have any other information in other fields as well? Is the B/W figure created by a formula in the spreadsheet that the pivot table is created from?
Amanda
