SUM BASED ON DIMENSION

[Qlikcommando]

I have data like below

Column1                          Column 2        Total

P	M	100
P	W	10
S	M	150
S	W	30

I want to have data that sums the Total based on Column2 value like what is in Total2

Column1                          Column 2    Total    Total2

P	M	100	250
P	W	10	40
S	M	150	250
S	W	30	40

Please can someone explain how to get there?

Thanks

[vinieme12 · Accepted solution]

As below , using TOTAL keyword

sum(TOTAL <Column2> Total)

refer this as well

https://community.qlik.com/t5/Qlik-Design-Blog/What-does-the-TOTAL-qualifier-do/ba-p/1472990

https://help.qlik.com/en-US/sense/February2022/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/defin...