Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be using this:
=If(Dimensionality() = 0, Sum({<Operation -= {'FSB'}>} LocationInv), Sum(LocationInv))
May be using this:
=If(Dimensionality() = 0, Sum({<Operation -= {'FSB'}>} LocationInv), Sum(LocationInv))
Hi Sunny,
Works perfectly. Thanks for your help