Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
dandaanilreddy
Partner - Creator III
Partner - Creator III

Additional row to pivot table

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

Labels (3)
2 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

Where does the data displayed in row labelled C come from? Is it just a duplicate of B? 

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
dandaanilreddy
Partner - Creator III
Partner - Creator III
Author

It’s A minus B.