jordanburch
Active Member
- Joined
- Jun 10, 2016
- Messages
- 440
- Office Version
- 2016
Hey guys
I have the below. I just need it to use the field "Total" or "Total " sometimes its different. Basically look for "Total" if its there in the data then use that field or if its "Total " then use that field. THanks!
Jordan
I have the below. I just need it to use the field "Total" or "Total " sometimes its different. Basically look for "Total" if its there in the data then use that field or if its "Total " then use that field. THanks!
Jordan
VBA Code:
With ActiveSheet.PivotTables("CARS").PivotFields("Total")
.Orientation = xlDataField
.Function = xlSum
.NumberFormat = "_($* #,##0.00_);_($* (#,##0.00);_($* ""-""??_);_(@_)"
.Name = "Total"
End With