Calculated Field "Grayed Out" in Pivot Table 1

[DeLaMartre]

I have a simple OLAP cube that I want to add a calculated field to, but the option is grayed out under formulas. I am a bit new to pivot tables, but I have followed instructions (books) carefully, but to no avail.

Am I doing something wrong, or is this an aspect of an OLAP cube?

Any help would be, as always, very much appreciated.

Thanks,

-Bob in California

 

[BlueHorizon]

Hi DeLaMartre,

According to Excel Help, you cannot create calculated fields or calculated items in reports with OLAP source data.

HTH,



Best,
Blue Horizon

http://www.bluehorizontraining.com

 

[DeLaMartre]

Thanks, Blue,

After having tried numerous book sources, I feel somewhat foolish for not having checked "Help" in my search for the solution.

Your kind assistance is appreciated. Red-faced, I now slink back into my seaside cave...

Thanks,

-Bob in California