Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I want to achieve the below highlighted row(A-B) in Qlik sense pivot table. Please can someone let me know how to achieve this?
Dimension 1 | Dimension2 | Quarter | Value | |
A | apple | Q1 | 10 | |
A | apple | Q2 | 20 | |
A | apple | Q3 | 30 | |
A | apple | Q4 | 40 | |
B | ball | Q1 | 5 | |
B | ball | Q2 | 10 | |
B | ball | Q3 | 15 | |
B | ball | Q4 | 20 | |
Sum of Value | Column Labels | |||
Row Labels | Q1 | Q2 | Q3 | Q4 |
A | 10 | 20 | 30 | 40 |
B | 5 | 10 | 15 | 20 |
C | 5 | 10 | 15 | 20 |
Thanks
Where does the data displayed in row labelled C come from? Is it just a duplicate of B?
It’s A minus B.