1 Reply Latest reply: Jun 13, 2014 9:01 AM by Rogerio Faria RSS

    A 'dimension' applying then selection, and another disconsidering selection

    Rogerio Faria

      Hi all,

       

      I need a way to show the Total of all expressions in 2 columns, 1 with current selection and another with the total of offices.

      It's a pivot table, and the dimension is in columns and the expressions are in rows.

      It cannot be another expression like 'sum({<office=>} value1)' because the result needs to be aside, not below.

       

      The qvw is attached. And the image will show what I need:

      print1.PNG.png

      Rogério