Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I change the order between fields and items in Pivot T?
Hi,
All the control you have of Calculation order in a pivot table is done as follows Place your cursor in the pivot table and choose Pivot Table, Formulas, Sort Order, then select the formula you want to calculate first and move it up or select any formula and move it up or down as desired. Remember, you don't have complete control of how and when your formulas calculate. -- Thanks, Shane Devenshire "Sergio Hernandez" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Specifying the order of pivot table calculated fields/items | Excel Discussion (Misc queries) | |||
pivot tables: Calculated fields among *row* items | Excel Discussion (Misc queries) | |||
Microsoft Query - Change the order of the fields | Excel Discussion (Misc queries) | |||
Fields change order from MS Query to Excel | Excel Discussion (Misc queries) | |||
Pivot tables - calculated fields and items | Excel Discussion (Misc queries) |