Home |
Search |
Today's Posts |
#1
|
|||
|
|||
pivot table
I want to convert a pivot tables results into %'s
|
#2
|
|||
|
|||
Hi
not sure what version this was introduced in - i'm running 2003, but if you create your pivot table as normal and then right mouse click n the data field and choose field settings, click on the options button you'll see a drop down box called Show data as - choose % or column or % of row depending on what you want and click OK -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "loren" wrote in message ... I want to convert a pivot tables results into %'s |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
pivot table | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
Removing errors from a Pivot table | Excel Discussion (Misc queries) | |||
Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions |