View Single Post
  #1   Report Post  
Gary L Brown
 
Posts: n/a
Default Solve Order of a CalculatedField in a Pivot Table

Does anyone know how to get the Solve Order of a CalculatedField in a pivot
table.

I know how to get the Solve Order of a CalculatedItem but can't seem to
get the CalculatedField!!!

An example of getting the Solve Order of a CalculatedItem is...
ActiveSheet.PivotTables(1).PivotFormulas(1).Index

Any help would be appreciated.

Thanks in advance.

Sincerely,
Gary Brown