Need Policy number wise aggr sales in qlik sense

[SyedBasha]

Hi Team,

I have couple fields in the dashboard in this I need policy number wise sales needed 

Example:

Policy number ,Sales

1, 1110

2,1110

3,1110

4,1110

5,1110

While I am writing the expression in kpi object like Sum(Sales) getting unique sales only(1110).

How will I getting the total sales i tried other methods as well Sum(total Sales) or aggr(sum(Sales), Policy Number) but no luck getting unique sum only, can anyone help me on this please

[Kushal_Chawda]

@SyedBasha  did you try Sum(distinct Sales) or sum(distinct aggr(sum( Value),[Policy number]))