Thread: Pivot Table field selection order
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Bony Pony[_2_] Bony Pony[_2_] is offline
external usenet poster
  
Posts: 71
Default Pivot Table field selection order
Hi Herbert,
Great solution! I was interested to know how you access the PT Wizard in
2007 ??

While looking for it, I found the answer tomy own question.

In PivotTable Tools Ribbon under the Options Tab in the PivotTable section
where the PivotTable name is there is an Options tab. Click this, select
Options and then the Display Tab. At the bottom is a Field List option that
sorts the Source Data as you like it.

Thanks for the steer though!! Good tip for the future!

Best regards,
Bony

"Herbert Seidenberg" wrote:

Excel 2007 Pivot Table
See comparison of the two types of PTs.
http://www.mediafire.com/file/yw4tjlmumzi/06_10_09.xlsx


Reply With QuoteReply With Quote