Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
devarasu07
Master II
Master II

how to show Grand total on Top of chart and subtotal at bottom?

Hi,

I've Detailed transnational report which has 1000 articles in a table/pivot table view. issue is here i need to show Grand Total at top and Material total (Sub Total) at bottom. how can we achieve this? thanks in advance.

Expected output:

Expect op.JPG

below is the current output:

Capture.JPG

Thanks

Deva

1 Solution

Accepted Solutions
sunny_talwar

Something like the attached

Capture.PNG

View solution in original post

2 Replies
sunny_talwar

You will have to use Pick(Dim....) technique to create Totals instead of using subtotals here

sunny_talwar

Something like the attached

Capture.PNG