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.
With that formula, I get this. 72, 70.
This is my script:
t_Ventas:
CrossTable(Mes, Ventas, 3)
LOAD Lab,
Tipo,
Coche,
Enero,
Febrero,
Marzo,
Abril
FROM
[New Microsoft Excel Worksheet.xlsx]
(ooxml, embedded labels, table is Hoja1);
And this is the Excel I'm loading:
Lab | Tipo | Coche | Enero | Febrero | Marzo | Abril |
Lab 1 | INGRESO | SI | 12 | 4 | 25 | 6 |
Lab 1 | GASTO | SI | 4 | 9 | 8 | 4 |
Lab 2 | INGRESO | nO | 1 | 5 | 6 | 8 |
Lab 2 | GASTO | NO | 11 | 13 | 14 | 12 |
hi Jose,
Try this, it is working with " sum(total <Mes> ventas) ".
PFA pic of it.
regards
harshal
hey Jose ,
This is the qvw with changes have a look at it.
regards,
harshal
Hi
Try Using this;
Sum(
(Total <Mes,Tipo> Ventas)
)
HTH
-Shruti