Forum Discussion
Sales Targets Incentives by Product and Rep
Hi I would like to calculate sales incentives % based on the % achievement of targets. I have different incentive payouts for different products and different employee role. In addition, some product...
Ashish_Mathur
Super User
Super UserHi,
In another worksheet of the MS Excel file, show the expected result very clearly.
Hi This is the expected result but I would like to a filter on top where the rep or manager can filter based on their role. I also attached the spreadsheet.
Expected Result
| Product | Sales | Target | SVT% | Incentives% |
| A | 950 | 1000 | 95.0% | |
| B | 1100 | 1050 | 104.8% | |
| C | 8500 | 9500 | 89.5% |