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.

1 Solution

Accepted Solutions
Not applicable
Author

Hi

Try Using this;

Sum(

(Total <Mes,Tipo> Ventas)

)

HTH

-Shruti

View solution in original post

14 Replies
Not applicable
Author

Hi Jose Manuel,

Do not understand much what you want to do, but did you try sth like:

sum(TOTAL Ventas)

?

Fabrice

vipin_mishra479
Creator II
Creator II

use

sum(TOTAL Ventas)

to get total value in ur all column

sudeepkm
Specialist III
Specialist III

I'm not sure but have you already tried enabling the properties of showing partial sum.

Chart Properties > Presentation > Show Partial Sum

Not applicable
Author

I've already have the partial sum. Is the last row of the table, but I want them in such a column

Not applicable
Author

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:

jvishnuram
Partner - Creator III
Partner - Creator III

Hi Jose,

Could you try this ,

Sum(Total <Lab> Ventas).

NareshGuntur
Partner - Specialist
Partner - Specialist

Hi Jose,

Can you post the document with sample data please?

Cheers,

Naresh

Not applicable
Author

Hi Jose,

PFA

I tried it and it is working.

use Rangesum(before(sum(ventas),0,2))  to get the desired output .

vipin_mishra479
Creator II
Creator II

Then use

Sum(Total <Lab> Ventas).

or

Sum(Total <Mes> Ventas).