Pivot Table Total - only certain dimensions

prees959 — Sat, 16 Nov 2024 04:37:37 GMT

Hi,

I have the following pivot table :

Stage	Unit A	Unit B	Unit C
Stage1	1	6	1
Stage2	1	1	-
Stage3	-	1	-
Stage4	-	8	7
Stage5	1	-	4

Is it possible to add a total row at the bottom to only sum Stage 4 and Stage 5 ? eg:

Stage	Unit A	Unit B	Unit C
Stage1	1	6	1
Stage2	1	1	-
Stage3	-	1	-
Stage4	-	8	7
Stage5	1	-	4
Final Stages	1	8	11

Many thanks,

Phil

Re: Pivot Table Total - only certain dimensions

dplr-rn — Tue, 29 Jan 2019 21:19:10 GMT

Use dimensionality.

as you have pivot table first enable totals. On the Presentation pane, select "show partial sums" for the first dimension. This will provide totals for the whole chart. If you want the total line to appear at the bottom, select "Subtotals at bottom" on the Presentation pane.

then your measure change it to something similar to below

if(dimensionality()=0,Sum({<Stage={'Stage 4','Stage 5'}>}YourColumn),Sum(YourColumn))

to understand dimensionality see this

https://community.qlik.com/t5/QlikView-Documents/How-to-use-Dimensionality/ta-p/1485559

topic Re: Pivot Table Total - only certain dimensions in QlikView

Pivot Table Total - only certain dimensions

Re: Pivot Table Total - only certain dimensions