Subtotals for colums and ROWS too!

[#1]

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?

[bgerchikov]

Hi Irene,

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

Hope it will help.

[#3]

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

[Clever_Anjos]

Hi Irene,

You should mark each column you want to be summarized

[Clever_Anjos]

PFA

[#6]

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

[Clever_Anjos]

Please post your expression here, let me check

[bgerchikov]

Can you attach application here?

[#9]

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

[Clever_Anjos · Accepted solution]

Use: sum([ProgDepQta Giacenza Attuale])

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