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?
Try like below