Pivot Table Solve Order

  • Thread starter Thread starter GHSMan
  • Start date Start date
G

GHSMan

I'm trying to change the solve order of formulas I've created inside a pivot
table. However, when I go to:

Formulas -> Solve Order

in the pivot menu, the
Calculated Item Solve Order
dialog box is empty.

I've used the

Formulas -> List Order

to produce the list. So, I can see the current order. But, I'd like to
change the order. How is this accomplished? Thanks!!!
 
Hi

The Solve Order refers to Calculated Items, not Calculated Fields.
I suspect that you have Calculated Fields in your PT, but you do not have
any Calculated Items

--
Regards
Roger Govier

GHSMan said:
I'm trying to change the solve order of formulas I've created inside a
pivot
table. However, when I go to:

Formulas -> Solve Order

in the pivot menu, the
Calculated Item Solve Order
dialog box is empty.

I've used the

Formulas -> List Order

to produce the list. So, I can see the current order. But, I'd like to
change the order. How is this accomplished? Thanks!!!



__________ Information from ESET Smart Security, version of virus
signature database 4798 (20100122) __________

The message was checked by ESET Smart Security.

http://www.eset.com
Click to expand...

__________ Information from ESET Smart Security, version of virus signature database 4798 (20100122) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 
Back
Top