Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Subtotals for colums and ROWS too!

Hi everyone, I'm trying to display subtotals for the different dimensions. I have flagged "Show Subtotals", but they don't appear (see attachment). Then I also need to add a column at the end of the table (see again picture) where there are rows' subtotals (like an excel pivot table). Is there a way to do it?

1 Solution

Accepted Solutions
Clever_Anjos
Employee
Employee

Use: sum([ProgDepQta Giacenza Attuale])

Expressions should have always an aggregation function (SUM,AVG,ONLY,etc)

View solution in original post

10 Replies
bgerchikov
Partner - Creator III
Partner - Creator III

Hi Irene,

you should check "Show Partial Sums" for every dimension you want to be totaled. not just for Dep.

Hope it will help.

Not applicable
Author

I have already flagged that parameter for each dimension, but I still cannot visualize the subtotal for the dimension Dep!

Clever_Anjos
Employee
Employee

Hi Irene,

You should mark each column you want to be summarized

Clever_Anjos
Employee
Employee

PFA

Capturar.PNG.png

Not applicable
Author

I have already done it! but it doesn't work...I don't see the subtotal for Dep...

Clever_Anjos
Employee
Employee

Please post your expression here, let me check

bgerchikov
Partner - Creator III
Partner - Creator III

Can you attach application here?

Not applicable
Author

here is the file and the chart is already open...it is called "Giacenze"..thanks

Clever_Anjos
Employee
Employee

Use: sum([ProgDepQta Giacenza Attuale])

Expressions should have always an aggregation function (SUM,AVG,ONLY,etc)