Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
KPI1 : Sum(Distinct ColC)
KPI2 : Count(DISTINCT ColB)
KPI1 : Sum(Distinct ColC)
KPI2 : Count(DISTINCT ColB)
Thank you for quick response