Solved: Re: Aggregate function - Page 2 - Qlik Community

Anonymous · ‎2012-02-01

sum(ValueINR) is not working correctly in pivot table

sum(valueINR is 1000000

but it show 40000 its column wise

kaushiknsolanki · ‎2012-02-01

HI,

Add straight table with dimension as region, and expression as Sum((Value INR) / sum( total (Value INR)

Have a look at the attched file.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!