Calculate wheight value

[francisco_cohen]

Hi,

I need to add a measure to calculate the wheight of each of my table rows:

Customer	Amount	Weight
A	500	27%
B	1000	54%
C	350	19%
TOTAL	1850	100%

How can I do this?

Thank you,

FC.

[dplr-rn · Accepted solution]

Use total qualifier
Assuming your Amount Expression is Sum(Amount)
new expression for weight Sum(Amount)/Sum(total Amount)
reference for the total qualifier below
https://community.qlik.com/t5/Qlik-Design-Blog/What-does-the-TOTAL-qualifier-do/ba-p/1472990