1 Reply Latest reply: Jun 13, 2014 9:01 AM by Rogério Faria RSS

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

    Rogério 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: