Cross table Total rows and colums settings

[Grazia Palmisano]

Hi all,

I have a simple cross table with:

- Display totals: Grand total for columns / rows checked

- Position of totals: Before values

- Calcuilation :Sum([PD Number]) THEN [Value] / Sum([Value]) OVER (All([Axis.Columns]))

- Calculate Totals: On underlying row values

 

I need that the setting Calculate Totals will be "On underlying row values" for "Grand total for columns" and "As the sum of cell values" for"Grand total for rows" but when i chage the setting Calculate Totals it applys to bothDisplay totals.

 

Is there a way to solve it

Thank you