LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Specifying the order of pivot table calculated fields/items Rick Excel Discussion (Misc queries) 1 August 10th 08 01:56 AM
pivot tables: Calculated fields among *row* items [email protected] Excel Discussion (Misc queries) 0 May 7th 08 07:46 PM
Microsoft Query - Change the order of the fields richard Excel Discussion (Misc queries) 0 July 20th 07 02:26 PM
Fields change order from MS Query to Excel maryj Excel Discussion (Misc queries) 3 January 31st 07 11:28 PM
Pivot tables - calculated fields and items Tim Wheeler Excel Discussion (Misc queries) 5 May 19th 06 10:06 PM


All times are GMT +1. The time now is 04:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"