| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Pivot Table Calculated Item
The Calculated Item selection is greyed out on the Pivot Tables/Formula drop
down menu. I have my cursor in a field that I want to calculate. What am I doing wrong? |
|
#2
|
|||
|
|||
|
If your pivot table is based on OLAP source data, you can't create
formulas. Could that be the problem? SamBayer1957 wrote: The Calculated Item selection is greyed out on the Pivot Tables/Formula drop down menu. I have my cursor in a field that I want to calculate. What am I doing wrong? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| 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 Grand Total - Calc Item | Excel Worksheet Functions | |||
| Pivot Table Calculated Item | Excel Discussion (Misc queries) | |||
| Item wise balance in Pivot Table | Excel Discussion (Misc queries) | |||
| How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
Linear Mode
