silentbuddha
Board Regular
- Joined
- Mar 1, 2008
- Messages
- 112
Hi All,
I'm trying to figure out how to solve this Unique Count situation based on multiple criteria
Scenario: we have agents from different departments who produce different sales on different plan rates
Raw Data
<tbody>
</tbody>
Matrix
<tbody>
</tbody>
Thanks
I'm trying to figure out how to solve this Unique Count situation based on multiple criteria
Scenario: we have agents from different departments who produce different sales on different plan rates
Raw Data
Employee | Plan Rate | Payout pts |
1 | 20 | 50 |
1 | 10 | 100 |
2 | 30 | 200 |
3 | 30 | 200 |
<tbody>
</tbody>
Matrix
Matrix | Plan Rates | Plan Rates | Plan Rates | Plan Rates | |
0 | 10 | 20 | 30 | ||
Sales Volume bucket | 1 | count of unique # of employees who made one sale on a plan_rate of 10. | |||
Sales Volume bucket | 2 | count of unique # of employees who made two sales on a plan_rate of 20. | |||
Sales Volume bucket | 3 | count of unique # of employees who made three sales on a plan_rate of 30. |
<tbody>
</tbody>
Thanks
Last edited: