I have recently created an an excel report based on an Olap Cube and I
now have all of my data organized into a pivot table in excel.

My only problem now is that I want to perform calculations on two of my
measures columns and create a new calculated field column based on the
result of those calculations. This sounds very easy to do I know but
when I click on the column and select the Pivot table menu -> Formulas
-> Calculated Field the Calculated Field option (as well as all of the
other formula options) are greyed out. I have run out of ideas to try. I
can 't get the Formula menu options to enable on any of my excel
applications actually. Does any one have any ideas as to what I can do?



Thanks.


--
Posted via http://dbforums.com

Have you ever found a way around this? Thanks a lot.

lc