Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

is there any way where we can get subtotal in the pivot table for rows and columns

i need subtotals for rows and the coulmns

ie

            exp   exp2     subtotal

             2         3        5

             4        5         9

subtotal  6        8         14

i am getting on to the right but not on the bottom i want on the both places

i am using only one dimention and 7-8 expressions

3 Replies
Gysbert_Wassenaar

You'll have to add an expression to sum the expressions for the subtotal for the expressions. Column(1) + Column(2) should work


talk is cheap, supply exceeds demand
Not applicable
Author

i tried that one but is there any other way than this

Not applicable
Author

thank you for your quick response