ExcelBanter - Pivot Table Calculated Item

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Pivot Table Calculated Item (https://www.excelbanter.com/excel-discussion-misc-queries/39895-pivot-table-calculated-item.html)

SamBayer1957

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?

Debra Dalgleish

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

All times are GMT +1. The time now is 08:37 AM.