| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Different format for Calculated Item in pivot table
I am using a Calculated Item to show the change between 2008 and 2007 sales,
and would like to have that shown as a percentage, but the format for Sum of Sales is a number. Is there a way to specify the percentage format in the formula such as =percent(('2008'-'2007')/'2007')? Thank you in advance for your replies. Chris |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculated Item in a Pivot Table | Excel Discussion (Misc queries) | |||
| Calculated Field and Calculated Item in Pivot Table | Excel Discussion (Misc queries) | |||
| pivot table formulas for calculated field or calculated item | Excel Discussion (Misc queries) | |||
| Pivot Table Calculated Item | Excel Discussion (Misc queries) | |||
| Pivot Table Calculated Item | Excel Discussion (Misc queries) | |||
Threaded Mode
