vba for pivot table for field "Total" or "Total "

[jordanburch]

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

With ActiveSheet.PivotTables("CARS").PivotFields("Total")
       .Orientation = xlDataField
       .Function = xlSum
       .NumberFormat = "_($* #,##0.00_);_($* (#,##0.00);_($* ""-""??_);_(@_)"
       .Name = "Total"
   End With