Change total in pivot table

[Anonymous]

Hi everyone,

I have a pivot table with 2 dimensions (operation and part) and 1 measure.  The table shows a partial sum for the dimension 'operation'.

I would like the partial sum to be over all dimensions, except for dimension 'FSB', while still showing 'FSB' in the table.  Is this possible ?

I have enclosed the qvw file.

All suggestions are welcome.

Thanks in advance.

[sunny_talwar · Accepted solution]

May be using this:

=If(Dimensionality() = 0, Sum({<Operation -= {'FSB'}>} LocationInv), Sum(LocationInv))

[Anonymous]

Hi Sunny,

Works perfectly.  Thanks for your help