You had the making of what you needed in there!
In the attached, in sheet "Calculated Table", I started using your stuff to create what you want to see.
PS: You should upload a packaged workbook (file extension .twbX) and not a .twb file. You get a packaged workbook doing FILE -> "Export Packaged Workbook" in desktop. BEcause you supplied the excel file, I was able to hook things up properly this time.
Factory 1.twbx 86.0 KB