Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
raynac
Partner - Creator
Partner - Creator

Subtotal of Top X Records

Wondering if anyone knows how to add a row of subtotals to this chart to subtotal the Top 10?  There are more columns but this should give you the idea:

I want to subtotal the numbers for the actual Top 10 and (ideally) not have the Remainder show as #9 when they are ranked.

I can move the totals to the bottom (they'd likely make way more sense there if the subtotals get added), but I cannot see any way to do this.

Any help would be appreciated.

1 Reply
isingh30
Specialist
Specialist

In presentation  click on  Show partial sums. Please include an expression for first 10 records. If it's not working then kindly share the data or app.

Thank you!