Subtotal by rows at the end

[beginnertom]

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!

[petter · Accepted solution]

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:

[Albert_Candelario]

Nice one!

Awesome seeing our MVPs solving the Community posts. Well done!