Forum Discussion
Resolver Ipower Bi Matrix-add total in same column
Hello,
I have matrix -under column - SITEID-"ALBIAN" "HORIZON" and LABORPAYCODE has lots. such as 801,802,814,809,826.... only 801 paycode represent for Regular time all other represent Overtime. I need have one column for regular time and one for overtime. In order to calculate overtime I need to add all paycode except 801.
| SITEID | LaborPayCode | ||||||||
| ALBIAN | ALBIAN | ALBIAN | ALBIAN | HORIZON | HORIZON | HORIZON | HORIZON | Grand Total | |
| 801 | 802 | 814 | 830 | 801 | 802 | 814 | 830 | ||
| 620 | 24 | 644 | |||||||
| 576 | 14.5 | 24 | 614.5 | ||||||
| 702 | 113 | 24 | 839 | ||||||
| 28 | 8 | 268 | 152 | 6.5 | 36 | 498.5 | |||
| 11 | 11 | ||||||||
| 324 | 1 | 325 | |||||||
| 505 | 24 | 529 | |||||||
| 36 | 156 | 48 | 1.5 | 241.5 | |||||
| 720 | 1 | 36 | 96.5 | 24 | 877.5 | ||||
| 32 | 45 | 2.5 | 8 | 4 | 2 | 93.5 | |||
| 456 | 186 | 36 | 678 | ||||||
| 72 | 72 | ||||||||
| 80 | 52 | 1 | 133 | ||||||
| 8 | 4 | 696 | 98.5 | 24 | 830.5 | ||||
| 4 | 12 | 16 | |||||||
| 96 | 48 | 1 | 188 | 134 | 12 | 479 | |||
| 708 | 79 | 36 | 823 | ||||||
| 92 | 28 | 86 | 36 | 24 | 266 | ||||
| 96 | 85 | 8.5 | 48 | 1.5 | 239 | ||||
| 6 | 4 | 8 | 18 | ||||||
| 590 | 40 | 25 | 36 | 691 | |||||
| 72 | 24 | 1 | 97 | ||||||
| 192 | 24 | 162 | 27 | 405 | |||||
| 36 | 24 | 460 | 144 | 2 | 36 | 702 | |||
| 760 | 56 | 2 | 24 | 842 | |||||
| 40 | 8 | 1.5 | 392 | 112 | 1.5 | 12 | 567 | ||
| 660 | 24 | 684 | |||||||
| 133 | 76 | 1 | 12 | 222 | |||||
| 504 | 24 | 528 |
Thanks,
ABC
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.
3 Replies
- serpiva64
Solution Sage
Hi,
in your table you select column Laborpaycode and group it this way
and then in your visual you use the groupd column instead of Laborpaycode
If this post is useful to help you to solve your issue consider giving the post a thumbs up and accepting it as a solution !
ABC11Hello 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.
