Hi,
We have a dashboard where we show the data of different employees and how the logged in employee and other employees are performing.An employee(employeename is locked at the time of login) can't see the other employee's earnings for the company but they can check how the other employees are performing.
Your performance(%) = column 3(Your Performance) / column 5(Total company Earnings)
Now I need help to calculate the Others peroformance percentage.
Others Peroformance % = OthersEarnings / (Total Comapny Earnings * No of Other employees) %
Here Others employees means, only those employees who has permission to sell atleast 3(> Half of the logged in employees car type) cars out of the 5 cars.
I am facing difficulties when I am trying to check the no of car types sold by an other employee as the data is locked for the logged in employee at the time of entry to the Dashboard.Please check the test data.
Car type | Your Earnings | Your Performance % | Others Performance % | Total company Earnings |
| 103276 | 5.70% | ? | 1812141 |
Sedan | 15000 | 15.00% | ? | 100000 |
Commercial Vehicle | 230 | 0.03% | ? | 812546 |
SUV | 85473 | 9.56% | ? | 894135 |
hatchback | 2123 | 42.46% | ? | 5000 |
Luxury | 450 | 97.83% | ? | 460 |