create a calculated field for pivot tables

G

Guest

I have created a Pivot Table (source is an OLAP Cube) and I would like to
create a calculated field that is the difference between 2 columns (not the
total), but since my source is an external OLAP cube I can't use the Pivot
Table toolbar function to create a calculated field. I have created the
Pivot Table in Excel 2007.

Is there a way to do this with VBA using the existing Pivot table that I
created? If so, how?
 
G

Guest

Nope (to the best of my knowledge). There is no way to do what you want. All
of the aggregation is done in the cube at the time it is created. There is no
facility to add another aggregation after that is complete.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 pivot tables - calculated fields and SSAS cube 3
Creating a Calculated Field in a Pivot Table for same field 3
Summarise data by average in OLAP cube 2
Pivot Table Dates Grouping Issue with Olap Cube 2
Unable to Group in Pivot Table 1
Changing Data Source on Multiple Pivot Tables at once 1
OLAP Pivot Table 1
Pivot table multiple filters 2

Top