Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
prees959
Contributor II

Pivot Table Total - only certain dimensions

Hi,

I have the following pivot table :

Stage Unit AUnit BUnit C
Stage1161
Stage211-
Stage3-1-
Stage4-87
Stage51-4

 

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

Stage Unit AUnit BUnit C
Stage1161
Stage211-
Stage3-1-
Stage4-87
Stage51-4
Final Stages1811

 

Many thanks,

Phil

 

Labels (2)
1 Reply
dilipranjith
Honored Contributor

Re: Pivot Table Total - only certain dimensions

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