Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Total in a column of pivot table

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.

14 Replies
Not applicable
Author

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

Not applicable
Author

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:

LabTipoCocheEneroFebreroMarzoAbril
Lab 1INGRESOSI124256
Lab 1GASTOSI4984
Lab 2INGRESOnO1568
Lab 2GASTONO11131412
Not applicable
Author

hi Jose,

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

PFA pic of it.

regards

harshal

Not applicable
Author

hey Jose ,

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

regards,

harshal

Not applicable
Author

Hi

Try Using this;

Sum(

(Total <Mes,Tipo> Ventas)

)

HTH

-Shruti