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

rogeriogyn — Mon, 26 Jan 2026 18:19:17 GMT

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

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

rogeriogyn — Fri, 13 Jun 2014 13:00:48 GMT

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