Add line items together

[Anonymous]

This is a sample of the data I load

ProductID	OrderID	Supplier	Total
77	80100	Advantage Parts Solutions	$5,025
77	80100	Advantage Parts Solutions	$5,025
77	80100	Advantage Parts Solutions	$5,025

I want to create a Qlik Sense table with an expression that will sum the 3 line items from the sample above to equal $15,075, however when I attempt to do so, with my current expressions, below is the Qlik Sense table I produce.

ProductID	OrderID	Supplier	Sum(Distinct[Total])	Sum([Total])
77	80100	Advantage Parts Solutions	$5,025	$45,225

Can you help?

[Anil_Babu_Samineni · Accepted solution]

Tr y this - Sum(TOTAL <ProductID, OrderID, Supplier> Total)

[tresesco]

This seems to be a data model issue. If you load only this table using INLINE, the problem should not be there. Could you try that and let know?