create a calculated field for pivot tables

L

Liesbeth

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?
 
J

Jim Thomlinson

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

Top