2 Replies Latest reply: Aug 22, 2016 11:13 AM by Filip Duchateau RSS

    Change total in pivot table

    Filip Duchateau

      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.