Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Subtotal for dimensions

Hello,

I was wondering if I could get some help please.

I have a list of sales team members and their sales in a pivot table. I would like to show the subtotal for each sales team as well as the grand total. Please see example below of current data set and what I would like to achieve.

Current dataset

Sales TeamNumber of dealsSales
Sales1223
Sales2740
Sales3325
Total1288

Desired Result

Sales TeamNumber od dealsSales
Sales1223
Sales2740
Sales3325
Total1288
Blue team963
Red team3

25

Many thanks,

Esther

4 Replies
maxsheva
Creator II
Creator II

Hi,

Please try Pivot table where should be selected option "show partial sum" per each dimension on the presentation tab.

Hope it will help you.

Max

Anonymous
Not applicable
Author

Hi Max,

It worked, thank you so much for your quick response.

Have a great evening!

Best,

Esther

Peter_Cammaert
Partner - Champion III
Partner - Champion III

devarasu07
Master II
Master II

Hi,

Refer to the attached sample using Valuelist method (synthetic dimension)

Capture.JPG