Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator 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
Highlighted
Partner
Partner

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