Use Pivot table Count Sale who can reach KPI

[panwipa2528]

I have raw Data as attach file and I need to count Sale person who can reach KPI by month.

1. Amount more than KPI  then will Count distinct from Sale_id

2. The correct result is 

[panwipa2528]

See result as picture

[panwipa2528]

@Sunny Talwar Need your help.

[Arthur_Fong · Accepted solution]

There you go:

Create flag at script level to determine Amount > KPI.

Refer attached qvw for reference.

Thanks and regards,

Arthur Fong