Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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