Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Use: sum([ProgDepQta Giacenza Attuale])
Expressions should have always an aggregation function (SUM,AVG,ONLY,etc)
Hi Irene,
you should check "Show Partial Sums" for every dimension you want to be totaled. not just for Dep.
Hope it will help.
I have already flagged that parameter for each dimension, but I still cannot visualize the subtotal for the dimension Dep!
Hi Irene,
You should mark each column you want to be summarized
PFA
I have already done it! but it doesn't work...I don't see the subtotal for Dep...
Please post your expression here, let me check
Can you attach application here?
here is the file and the chart is already open...it is called "Giacenze"..thanks
Use: sum([ProgDepQta Giacenza Attuale])
Expressions should have always an aggregation function (SUM,AVG,ONLY,etc)