Pivot Table Total - only certain dimensions

[prees959]

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

[dplr-rn]

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