| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table calculate field
Hi All,
I have a source of data formatted as below: Retailer No. | Desc. | Value 004 | Total hours | 5000 004 | Retail hours | 2500 009 | Total hours | 6000 009 | Retail hours | 3000 I have a pivot table looking at this data source and I want to include a field that performs the calculation '= [Retail hours]/[Total hours]' unfortunately only the field 'Desc' is shown as a title in the pivot table to I cant do calculate field as the data isnt setup that way. Does anyone know a way to do what i need? Many Thanks -- Adam ----------- Windows XP + Office Pro XP |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sum a pivot table field as a calulated field | Excel Discussion (Misc queries) | |||
| Pivot Tables - calculate field? | Excel Discussion (Misc queries) | |||
| Pivit table- cell on spread sheet referencing pivot table field | Charts and Charting in Excel | |||
| How to make a field created a part of the Pivot Table Field List? | Excel Discussion (Misc queries) | |||
| How can I calculate a percentage of a YES/NO field in a Pivot Tab | Charts and Charting in Excel | |||
Threaded Mode
