View Single Post
  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

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