Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to get the sum of all the values of a table in a column but i'm can't get them.
This is my table (and some of my tries...):
Mes and Lab are the dimensions.
What I want, is to get the TOTAL, but in a column.
I was able to get it with the Aggr(Sum(Ventas), Mes), but it only appear in the first row.
Basically, the real thing I want is just to have a column, with the value / total value of that column .
Thanks in advance.
Hi Jose Manuel,
Do not understand much what you want to do, but did you try sth like:
sum(TOTAL Ventas)
?
Fabrice
use
sum(TOTAL Ventas)
to get total value in ur all column
I'm not sure but have you already tried enabling the properties of showing partial sum.
Chart Properties > Presentation > Show Partial Sum
I've already have the partial sum. Is the last row of the table, but I want them in such a column
If I use sum (TOTAL Ventas) I'll get the sum of all the Ventas of all the Mes (Month).
I show a picture:
What I want in the second column intead of 142, is the 30 (the sum of Ventas of that particular Mes)
Something like this:
Hi Jose,
Could you try this ,
Sum(Total <Lab> Ventas).
Hi Jose,
Can you post the document with sample data please?
Cheers,
Naresh
Hi Jose,
PFA
I tried it and it is working.
use Rangesum(before(sum(ventas),0,2)) to get the desired output .
Then use
Sum(Total <Lab> Ventas).
or
Sum(Total <Mes> Ventas).