Forum Discussion

Joshi_M's avatar
Joshi_M
Helper I
3 years ago

User Input for Multiple Values in an added column in table.

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

 

LocationProcessMachineShift PatternSimulated Shift Pattern
AXX117X36X3
AYY216X35X3
AZZ515X34X3
BXX114X34X1
BXX125X26X3
BYY226X37X3
No RepliesBe the first to reply