Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi @dennysetiawan
Try like below
https://community.qlik.com/t5/New-to-Qlik-Sense/How-to-Add-total-and-distribution-field-in-pivot-tab...