Pivot table field settings--ghosted out

[Scott Reoch]

I'm MS-Excel 2003 pivot tables which connect to an OLAP database. I am 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 cell heading...same result) and select "FIELD SETTINGS". This brings up the Pivot table field window. The only options that I have that are not ghosted out are "AUTOMATIC" and "NONE".

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

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

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

Scott

[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.

Scott Reoch wrote:
> I'm MS-Excel 2003 pivot tables which connect to an OLAP database. I am
> 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 cell
> heading...same result) and select "FIELD SETTINGS". This brings up the
> Pivot table field window. The only options that I have that are not
> ghosted out are "AUTOMATIC" and "NONE".
>
> I understand that I need to tick the CUSTOM radio button under the
> Subtotal heading, but i am unable to do so, as it's ghosted.
> Consequently the Sum/Count/Average/Max/Min... options are also
> unavailable.
>
> This is the case with all of my spreadsheets that connect to this OLAP
> database.
>
> Is there a global setting that can be reset on Excel? Or is this a
> setting in our OLAP cubes? Or is there something else?
>
> Scott
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

[[email protected]]

yeah you need to have your olap developer do that