topic Re: Subtotal by rows at the end in QlikView

Subtotal by rows at the end

beginnertom — Sat, 16 Nov 2024 20:30:34 GMT

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!

Re: Subtotal by rows at the end

petter — Sun, 07 Jul 2019 09:21:23 GMT

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:

Re: Subtotal by rows at the end

Albert_Candelario — Sun, 07 Jul 2019 12:11:21 GMT

Nice one!

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