Sum or Get Values of Field from Distinct Field

[Zaidan_as]

Hello guys, 
As i stated in the subject, I want to get the values or sum the values of a field from distinct name of another field. 

The illustration is like this

so if you see on the image, I want to just get the distinct value from Inspect (column G) from distinct name of the EPLotNo (column B). 
So example from the image,  I want to get value like this

So how can I get this in Qlik Sense using expression ?

[Zaidan_as · Accepted solution]

Ok i already found the answer, my bad because i don't search more in the qlik community first.

My solution is using this expression
SUM(AGGR(SUM(DISTINCT TotalInspectionQty), EPLotNo))