Exporting a totals column from SharePoint to Excel

I've successfully exported the content of a tracking tool to 2 Excel Worksheets in the same workbook, 1 of which has a Pivot Table. The challenge I'm faced with is creating a column that calculates the totals of my criteria in the tab where the Pivot Table has been placed.  The idea is that the column containing the totals synchronizes with SharePoint along with the rest of the workbook.


There are a total of 63 items of that are under the category of "Requesting MTF/Unit" and a total of 25 items of that are under the category of "Event Type".


Any input on how to approach this would be greatly appreciated.  Here are some screen caps that I think will give some insight as to what I'm working on. . .

0 Kudos