Execl 2007 Pivot Olap calculated Field

[Manfred Steinbacher]

Hallo

I have created an Pivotreport in Excel 2007. The source of these report is a
Cube (Sql-Server 2005).
I have two fields (Amount and Quantity), which I get from the cube.
Now I want to generate a field, which is the product from Amount/Quantity. I
thing this will be named calculated Field in Excel. But it is impossible to
create this, because this command isn´t active.
How can I solve this problem.

Regards
Manfred

 

[ShaneDevenshire]

Hi,

You can't create a calculated field from an olap (cube) file. If you want
to make this calculation you will need to do it outside the pivot table.