Pivot table show more than one subtotal in only one expression

[dennysetiawan]

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? 

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?

[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...