Can you mock up your expected output for the visualization? If there are many sheets in the attachment, which ones should we be looking at? Any more detail you can provide may also help. Thanks and best wishes!
Ahh, so Table Calcs are based on whatever Dimensions you have in the view. The dimensions you have in your first sheet will also be needed in any other sheets, if you want to calculate based off of those results. It is possible, but I'm a bit unclear on what the expected results should look like in Tableau. I hope this helps a bit!