Summary Table For Multiple Variables

[#1]

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. 

TFranke_3-1636796028207.png

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?

[#2 · Accepted solution]

You can also try tabulate:

jthi_0-1636800460388.png

you can turn it to datatable from red triangle menu:

jthi_1-1636800560998.png

jthi_6-1636800837997.png

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:

jthi_2-1636800665443.png

Select either N Rows and either N(Green) or N(Red), right click on selected column and create new formula column:

jthi_3-1636800728993.png

Table after sorting, additional formulas and formatting:

jthi_5-1636800808787.png