Help! I'm have some data which shows the workload in a factory in man hours.
I would like to rank this data by the sum of the highest workload measured in machine hours with three criteria which are the customer, week and Production line.
Each customer can have more than one job per week which makes the rank function skip values. I would like the rank to not miss numbers in the sequence when ranking.
Once the data has been prepared I would like to display it in a stacked bar chart. With each weeks machine hours represented as a stacked colum on the chart. I would like the stacked column to show 4 values. The workload of the top 3 customers for that week and the rest of the customers just labelled as other.
Thanks!
I would like to rank this data by the sum of the highest workload measured in machine hours with three criteria which are the customer, week and Production line.
Each customer can have more than one job per week which makes the rank function skip values. I would like the rank to not miss numbers in the sequence when ranking.
Once the data has been prepared I would like to display it in a stacked bar chart. With each weeks machine hours represented as a stacked colum on the chart. I would like the stacked column to show 4 values. The workload of the top 3 customers for that week and the rest of the customers just labelled as other.
Thanks!
