Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
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

Something like the attached

Capture.PNG

View solution in original post

2 Replies

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

Something like the attached

Capture.PNG

View solution in original post