How to Add Subtotals using Amounts

I have this code that adds up amounts according to a data report sheet (Concur Data). I will provide my automation and excel below. If you run my automation with the right path it makes 3 more sheets that try to duplicate the pivot tables I provided in the same excel worksheet. How would I find the subtotals as shown under “Total” in bold?

Main - Copy.xaml (37.8 KB)

COPY 2021 YTD Weekly Billing Expense Allocation.xlsx (63.7 KB)

Example of the subtotals under “Total” (Also in excel worksheet)

@Pranav_KomandurPK - Duplicate of

Sorry, I didnt get a response the last time so I attempted to post again

@Pranav_KomandurPK - Please do not cross post same query multiple times, I see you already opened up 3 posts on the same topic…

1 Like