Total in a column of pivot table

[#1]

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.

[#2]

With that formula, I get this. 72, 70.

[#3]

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

[#4]

hi Jose,

Try this, it is working with " sum(total <Mes> ventas) ".

PFA pic of it.

regards

harshal

[#5]

hey Jose ,

This is the qvw with changes have a look at it.

regards,

harshal

[#6 · Accepted solution]

Hi

Try Using this;

Sum(

(Total <Mes,Tipo> Ventas)

)

HTH

-Shruti