Created:
| Last Modified:
I have a dataset fundamentally similar to the table below on the left. I need to summarize it to look like the table on the right, calculating the % of lines for each entry in the completed column for each shift for each time period. In a practical sense, a shift completed 2 red and 1 green during FM1, so the summary would need to find the % of red and green found by a shift during FM1... etc.
It is not feasible to make subsets for shift and time, since I will need to plot Green% vs Time by Shift. I've tried several summary table options but they all fail to calculate % of total for the completed category independently for Time and Shift, have yet to find an option that can treat them separately, has anyone ran into this issue before?
1 ACCEPTED SOLUTION
Accepted Solutions
You can also try tabulate:
you can turn it to datatable from red triangle menu:
With Summary table you might need to do some extra calculations either before or after creation of the Summary. Below is example doing them after:
Select either N Rows and either N(Green) or N(Red), right click on selected column and create new formula column:
Table after sorting, additional formulas and formatting:
You can also try tabulate:
you can turn it to datatable from red triangle menu:
With Summary table you might need to do some extra calculations either before or after creation of the Summary. Below is example doing them after:
Select either N Rows and either N(Green) or N(Red), right click on selected column and create new formula column:
Table after sorting, additional formulas and formatting: