Sum a column

[e_guerra]

Hello everyone

I'm new in Qlik and  have a doubt...

I have a pivot table with many columns but one of them is the next expression: sum(Volume)*(Sum(Aggr(Avg(Price),[Commercial name])))

then i would like to get the total sum of that column in another one, how can i do that??

Thanks in advance

[its_anandrjs]

Hi,

Can you elaborate more or share the sample data or you try with

Sum(Volume) * (Sum(TOTAL  Aggr(Avg(Price),[Commercial name] ) ) )

Regards

Anand

[e_guerra]

Hi Anand

Sure in the 4th column (Volume*Price) is the expression: sum(Volume)*(Sum(Aggr(Avg(Price),[Commercial name])))

and in the next column (sum Vol*Price) i need to sum each value of the previous column, and your expression doesn't work