Hello Sam Fleisher,
I have created a Tableau workbook from your data example (thank you for supplying) that matches the spreadsheet pretty closely. The hardest part of the setup was to turn off subtotals at the Event Nid level by selecting the field from the Rows shelf and de-selecting the "Sub-Totals" box after turning it on for All levels.
I hope this helps. It should at least get the conversation started related to what you are working on versus what is in the example. The attached workbook is in Version 10 of Tableau.
Sample_Data_example.twbx 72.3 KB