Pivot without some totals

[clovati]

Hi all.

I have a pivot and, for some expression, I don't want their totals at the right. In expression I an't select NO TOTALS and also in presentation I can't say not tu sum. thanks in advace!

[MK9885]

To remove totals uncheck the 'Show Partial Sums'  for Dimension values in presentation tab.

It will remove Totals for the expression column for that particular dimension only.

I do not know other way around to do it, maybe a Qlik expert can suggest more?

[#3]

Check @Stefan Wühl solution here How to Remove Total & Sub Total from One Column in Pivot Table?

[javierortiz79]

Hello Cristina,

Create a new expression and enter this: Dimensionality(),

That will give you a number for your totals, then use that number for an if condition in your expresion you don't need the totals, like this:

If(Dimensionality() = 1, sum(sales), )

Assuming that the result for the total of Dimensionality() <> 1.

This will solve your issue.

Regards!

[maxgro · Accepted solution]

dimensionality for colums

secondarydimensionality for rows (pivot)