View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sergio Hernandez Sergio Hernandez is offline
external usenet poster
 
Posts: 1
Default How do I change the order between fields and items in Pivot T?

I have calculated field on a Pivot Table, and then I have a calculated item
that uses the information previously calculated. My problem is that the PT
calculates the item first, and then the field. How can I change that order?
(first field and the item) Because in the "solve order" option, you can only
make changes between items, but not between items and fields.

SH