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

[rogeriogyn]

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:

Rogério

[rogeriogyn · Accepted solution]

It's more simple than I tought.

it's just use the function Dimensionality()

And the expressions goes like:

     IF(Dimensionality()=1, sum(value1), sum({<office=>}value1))

The qvw is attached