Hi,
I have a sample table as shown below.The information below is used on capacity calculation.
The shift pattern determines the days per week & hours per day. which is used in capacity calculation
There are several locations /machines so the combination could be many.
I want the user to be able to add/edit diffrent shift pattern in the simulated column.
I will probably have a slicer for Location & Process so easy for user to update.
How to achieve this? i have been thinking and reading post but could not find this kind of solution.
The values in the simulated column will be used to compare current with simulated one.
Hope the explanation is clear. Workaround is also welcome.
Kindly help.
Regards
Manish
| Location | Process | Machine | Shift Pattern | Simulated Shift Pattern |
| A | XX | 11 | 7X3 | 6X3 |
| A | YY | 21 | 6X3 | 5X3 |
| A | ZZ | 51 | 5X3 | 4X3 |
| B | XX | 11 | 4X3 | 4X1 |
| B | XX | 12 | 5X2 | 6X3 |
| B | YY | 22 | 6X3 | 7X3 |
