ExcelBanter - Solve Order of a CalculatedField in a Pivot Table

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Solve Order of a CalculatedField in a Pivot Table (https://www.excelbanter.com/excel-discussion-misc-queries/42267-solve-order-calculatedfield-pivot-table.html)

Gary L Brown

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

All times are GMT +1. The time now is 03:48 PM.