Averaging Subtotal for Excel OLAP Pivot from the Project Server Cube

[Vinnyliphoo1]

Hi There

I'm not sure I'm in the right newsgroup...

I've created a pivot table from the olap cube, that was easy.

What I want to do is take show the subtotal as an average of the
values above it. Unfortunately, it seems that the ability to change
the subtotal value is greyed out.

Any ideas how I can do this?

I'm using Excel 2007 & Project Server 2003, underpinned by SQL2005

Thanks
Vincent

 

[Dale Howard [MVP]]

Vincent --

The think the only way around your problem is to export the PivotTable to
Excel and then manipulate the data in Excel so that you get the full
capabilities of Excel. Hope this helps.

 

[Vinnyliphoo1]

Vincent --

The think the only way around your problem is to export the PivotTable to
Excel and then manipulate the data in Excel so that you get the full
capabilities of Excel.  Hope this helps.














- Show quoted text -

Just as a feared, thanks for the prompt response Dale!