Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dennysetiawan
Partner - Contributor III
Partner - Contributor III

Pivot table show more than one subtotal in only one expression

Dear Expert,

As illustrated in the subject, I have 3 dimensions (Product Code, Product Desc., Month) and 1 expression Sum(Sales).

Can I create chart using pivot table that expected result like this? 

dennysetiawan_0-1620372284633.png

When I tried it, I found it's difficult to to make 2 subtotals (Total Sales, Avg Sales) with 1 expression.

Do you have any idea?

Labels (2)
1 Reply
MayilVahanan

Hi @dennysetiawan 

Try like below

https://community.qlik.com/t5/New-to-Qlik-Sense/How-to-Add-total-and-distribution-field-in-pivot-tab...

 

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.