Need count of Regions which sales reached the target.

[Muralisaiganesh]

Load * Inline

[

Region, City, Sales, Target

R1, AAA, 20, 25

R1, BBB, 30,20

R2, CCC, 40, 35

R3, DDD, 30, 25

R4, EEE, 40, 50

R4, FFF, 30, 35

];

So in the above the region which reached the target are - R1, R2, R3

Expected Output:

In KPI 

Total count of Regions where the target is reached = 3

[Antoine04 · Accepted solution]

Hello,

Does it fit you expectation like this ?

Best Regards,

Antoine L

[Anil_Babu_Samineni]

@Muralisaiganesh Perhaps this?

Count(If(Sales>Target,Region))

[Muralisaiganesh]

Thanks @Antoine04 

This worked Perfectly.

[Antoine04]

Perfect @Muralisaiganesh ! Could you please put my answer as solution in the topic ? 🙂

Thanks !