Forum Discussion
Resolver Ipower Bi Matrix-add total in same column
Hi, ABC11
You can add a new calculated column 'Lable Time' to replace your original field 'LaborPayCode' in your matrix visual.
Lable Time = IF('Table'[LaborPayCode]=801,"1Refgular time","2Over Time")Please check my sample file for more details.
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Resolver IHello Serpiva64,
Thanks for your time. This will put togather only paycode. I would like to add overtime base on laborpaycode. This is matrix table. Only 801 paycode is for Regulatime. 802,814,830 all these are represent ovetime hrs.
| SITEID | LaborPayCode | ||||||||||
| ALBIAN | ALBIAN | ALBIAN | ALBIAN | HORIZON | HORIZON | HORIZON | HORIZON | ||||
| Employee name | Employee NO | 801 | 802 | 814 | 830 | Total | 801 | 802 | 814 | 830 | Total |
| Tara | 30000 | 620 | 24 | 644 | |||||||
| Mita | 30001 | 576 | 14.5 | 24 | 614.5 | ||||||
| Ryan | 30002 | 702 | 113 | 24 | 137 | ||||||
| Dinah | 30003 | 28 | 8 | 8 | 268 | 152 | 6.5 | 36 | 462.5 | ||
| Kim | 30004 | 11 | |||||||||
| Reena | 30005 | 324 | 1 | 1 | |||||||
| Nola | 30006 | 505 | 24 | 24 | |||||||
| Farah | 30007 | 36 | 156 | 48 | 1.5 | 205.5 | |||||
| Dylan | 30008 | 720 | 1 | 36 | 37 | 96.5 | 24 | 120.5 | |||
| Mike | 30009 | 32 | 45 | 2.5 | 47.5 | 8 | 4 | 2 | 14 | ||
| Rose | 30010 | 456 | 186 | 36 | 222 | ||||||
| Neail | 30011 | 72 | |||||||||
| Jit | 30012 | 80 | 52 | 1 | 53 |
My output should be
| Employee name | Employee NO | Horizon Regular time | Horizon Overtime | Horizon Total time | Albian Regulartime | Albian Overtime | Albian TotalTime | ||
| Tara | 30000 | 620 | 24 | 644 | 137 | 137 | |||
| Mita | 30001 | 576 | 38.5 | 614.5 | 8 | 8 | |||
| Ryan | 30002 | 702 | 702 | ||||||
| Dinah | 30003 | 268 | 194.5 | 462.5 | 28 | 1 | 29 | ||
| Kim | 30004 | 11 | 24 | 35 | |||||
| Reena | 30005 | 324 | 324 | ||||||
| Nola | 30006 | 505 | 37 | 542 | |||||
| Farah | 30007 | 156 | 49.5 | 205.5 | 36 | 47.5 | 83.5 | ||
| Dylan | 30008 | 120.5 | 120.5 | 720 | 222 | 942 | |||
| Mike | 30009 | 8 | 6 | 14 | 32 | 32 | |||
| Rose | 30010 | 456 | 53 | 509 | |||||
| Neail | 30011 | 72 | 72 | ||||||
| Jit | 30012 | 80 | 80 |
- v-easonf-msft
Community Support
Hi, ABC11
You can add a new calculated column 'Lable Time' to replace your original field 'LaborPayCode' in your matrix visual.
Lable Time = IF('Table'[LaborPayCode]=801,"1Refgular time","2Over Time")Please check my sample file for more details.
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.