Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

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
Highlighted
Creator II
Creator II

Re: Subtotal for dimensions

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

Highlighted
Contributor III
Contributor III

Re: Subtotal for dimensions

Hi Max,

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

Have a great evening!

Best,

Esther

Highlighted

Re: Subtotal for dimensions

Highlighted
Master II
Master II

Re: Subtotal for dimensions

Hi,

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

Capture.JPG