Need help with Qlikview KPI Expression

[itsme123]

Need help in create below two KPI's

First KPI  :   column b 123 has amount $10 and 444 has $40 i just need to pick distinct value of col b and there respective amount to be sum $10 +$40 = 50 this should be my KPI result

Second KPI : I need distinct count of col b = 2 should be my KPI result

ColA	ColB	ColC
1	123	$10
2	123	$10
3	123	$10
4	123	$10		KPI 1
5	123	$10		Col c $10+$40
1	444	$40
2	444	$40		KPI 2
3	444	$40		Distinct of col b count
4	444	$40
5	444	$40

[Anil_Babu_Samineni · Accepted solution]

KPI1 : Sum(Distinct ColC)

KPI2 : Count(DISTINCT ColB)

[itsme123]

Thank you for quick response