topic Re: Change total in pivot table in App Development

Change total in pivot table

Anonymous — Mon, 22 Aug 2016 15:01:15 GMT

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 — Mon, 22 Aug 2016 15:07:36 GMT

May be using this:

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

Anonymous — Mon, 22 Aug 2016 15:13:01 GMT

Hi Sunny,

Works perfectly. Thanks for your help