Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
dennysetiawan
Partner
Partner

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