Automatically insert subtotals help

fklioside

Board Regular
Joined
May 6, 2013
Messages
51
I have a pivot table with multiple subtotals. Off to the right, we added manual adjustment columns not part of the pivot table. Is there a way to automatically insert subtotals (highlighted in yellow bellow) for the manually added columns? I have thousands of rows of data so manually creating subtotals is not ideal.

Was thinking there has to be some sort of formula we can use with IF statements that would say IF right(A1,6)="Total" then find subtotal range until the next "Total". Not sure what is possible or what would be the approach.



Any help would be greatly appreciated. Thank you!
 

Forum statistics

Threads
1,082,505
Messages
5,365,965
Members
400,864
Latest member
RobynP51

Some videos you may like

This Week's Hot Topics

Top