Pivot table field settings--ghosted out

[Scott Reoch]

I'm MS-Excel 2003 pivot tables which connect to an OLAP database. I a
trying to set my subtotals in the pivot table to "AVERAGE". Currently
they're defaulting to the "SUM" setting.

I right click on the cell (I do this for both the cell and the cel
heading...same result) and select "FIELD SETTINGS". This brings up th
Pivot table field window. The only options that I have that are no
ghosted out are "AUTOMATIC" and "NONE".

I understand that I need to tick the CUSTOM radio button under th
Subtotal heading, but i am unable to do so, as it's ghosted.
Consequently the Sum/Count/Average/Max/Min... options are als
unavailable.

This is the case with all of my spreadsheets that connect to this OLA
database.

Is there a global setting that can be reset on Excel? Or is this
setting in our OLAP cubes? Or is there something else?

Scot

 

[Debra Dalgleish]

When the pivot table is based on an OLAP database, you can't change the
summary function for the row and column field subtotals.

 

[aaron.kempf]

yeah you need to have your olap developer do that