Forum Discussion
Table creation
Hi All
I need a help to create table like below examples , could you please help. Not a able to attach excel file .
No of audit each 1 marks is 17 marks., mean Manindar March month did 6 audit marks got 93, over all marks is 102( 6 Audit marks * 17 Marks =102)
Incident ManagerIncident Manager97.97%92.94%98.19%90.79%92.44%87.75%Grand Total
| March'24 | April'24 | May'24 | OverAll Performance (YTD) | |||||||||
| No.of Audits | Marks Secured | Achieved (%) | No.of Audits | Marks Secured | Achieved (%) | No.of Audits | Marks Secured | Achieved (%) | Total Incidents | Total Points | Overall (%) | |
| Manindar | 6 | 93 | 91.18% | 15 | 254 | 99.61% | 8 | 136 | 100.00% | 29 | 483 | |
| Lasya | 6 | 76 | 74.51% | 10 | 166 | 97.65% | 9 | 153 | 100.00% | 25 | 395 | |
| Mohan | 5 | 85 | 100.00% | 3 | 47 | 92.16% | 5 | 85 | 100.00% | 13 | 217 | |
| Valli | 3 | 41 | 80.39% | 12 | 182 | 89.22% | 8 | 132 | 97.06% | 23 | 355 | |
| Sanjana | 7 | 100 | 84.03% | 9 | 147 | 96.08% | 5 | 83 | 97.65% | 21 | 330 | |
| Chaithanya | 8 | 114 | 83.82% | 3 | 48 | 94.12% | 1 | 17 | 100.00% | 12 | 179 | |
| 35 | 509 | 76.54% | 52 | 844 | 85.43% | 36 | 606 | 88.60% | 123 | 1959 | 83.83% | |
| Manindar | 102 | 255 | 136 | 493 | ||||||||
| Lasya | 102 | 170 | 153 | 425 | ||||||||
| Mohan | 85 | 51 | 85 | 221 | ||||||||
| Valli | 51 | 204 | 136 | 391 | ||||||||
| Sanjana | 119 | 153 | 85 | 357 | ||||||||
| Chaithanya | 136 | 51 | 17 | 204 | ||||||||
| Grand Total | 665 | 988 | 684 | 2337 |
The table should be like below example, Please any one help .
3 Replies
Hi,
Your ask is not clear to me. you want to create a calculated table manually like this or you already have a dataset and wants to represent that in this way??
Hi Rupak_bi ,
Actually that dashboard in excel now need to created power bi , please help to create
1. count No of audits.
2. Marks secured.
3. Total Marks
4. Achived percentage.
5. OverAll Performance (YTD).
Incident ManagerIncident ManagerGrand Total
March'24 April'24 May'24 OverAll Performance (YTD) No.of Audits Marks Secured Total Marks Achieved (%) No.of Audits Marks Secured Total Marks Achieved (%) No.of Audits Marks Secured Total Marks Achieved (%) Total no of audits Total Marks Secured Total Marks Manindar 6 93 102 91.18% 15 254 255 99.61% 8 136 136 100.00% 29 483 493 Lasya 6 76 102 74.51% 10 166 170 97.65% 9 153 153 100.00% 25 395 425 Mohan 5 85 85 100.00% 3 47 51 92.16% 5 85 85 100.00% 13 217 221 Valli 3 41 51 80.39% 12 182 204 89.22% 8 132 136 97.06% 23 355 391 Sanjana 7 100 119 84.03% 9 147 153 96.08% 5 83 85 97.65% 21 330 357 Chaithanya 8 114 136 83.82% 3 48 51 94.12% 1 17 17 100.00% 12 179 204 35 509 665 76.54% 52 844 889.9047693 94.84% 36 606 618.6366514 97.96% 123 1959 2097.926632
