Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I would like to find a solution to show the total sum by row(not by column) and put it in last.
The dataset I use is based on the one post in the forum,
You see the total 1 is show in all dimension column by not only show it in the end.
Total by Qlik
All i want is like excel pivot table, show row total at the end(which label in yellow)
Sum total by Rows
Hope everyone who read this post can help.Thz!
To show how it can be made similar to what you do in an Excel Pivot Table I had to disable the three expressions Total1, SALES QTY and P.T. Then I had to select SHOW SUBTOTALS in the Presentation Tab for PRODUCT SUB CATEGORY:
To show how it can be made similar to what you do in an Excel Pivot Table I had to disable the three expressions Total1, SALES QTY and P.T. Then I had to select SHOW SUBTOTALS in the Presentation Tab for PRODUCT SUB CATEGORY: