Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
joe_mccorkel
Partner - Contributor
Partner - Contributor

Overall total row on pivot table

Hello!

I am looking for a way to add an overall total column to this pivot table. I have partial sum selected for the first column(along with others). I am also using dimensionality() in the expressions to show subtotals only on certain expressions. Any thoughts?

qliksubtotal.png

2 Replies
vinieme12
Champion III
Champion III

Sorry are you trying to add a new Expression or you want to only show subtotals for particular expressions and hide for the rest?

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
joe_mccorkel
Partner - Contributor
Partner - Contributor
Author

I want to add a total line on the absolute bottom. I have partial sums on for the buy/sell column already