Dear helper,
The following is a fragment from a table. The table shows routings with required work centers. What would be the easiest way to make an overview of volume (KG) per workcenter in monthly buckets (Date)?
<colgroup><col span="3"><col><col span="6"></colgroup><tbody>
</tbody>
Help is much appreciated!
Warm regards
The following is a fragment from a table. The table shows routings with required work centers. What would be the easiest way to make an overview of volume (KG) per workcenter in monthly buckets (Date)?
Date | KG | Routing | WC1 | WC2 | WC3 | WC4 | WC5 | WC6 | WC7 |
1/16/2017 | 1.667 | TOFSPD002 | SE1 | RI | DRPR1 | BR1 | BB1/TT 1 | DRPR1 | ASL1 |
1/8/2017 | 6632 | CACSP004 | SZ1 | DG1 | DR1 | SP | |||
3/10/2017 | 0.52 | LTLSPD002 | CD1 | ASL1 | ICL1 | ICL1 | DR1 | NR | SP |
3/10/2017 | 0.499 | LTLSPD002 | CD1 | ASL1 | ICL1 | ICL1 | DR1 | NR | SP |
1/14/2017 | 262.761 | WMWSP001 | ASL1 | HA1 | SP |
<colgroup><col span="3"><col><col span="6"></colgroup><tbody>
</tbody>
Help is much appreciated!
Warm regards