View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jim Plant Jim Plant is offline
external usenet poster
 
Posts: 1
Default Excel Pivot Table, Property Fields

Hello Excel Discussion Group,

I have a Pivot Table whose data is derived from an Analysis Services
database.

I can add member properties (known as Property Fields in Excel 2007) to the
pivot table - however when I try to change the order of the property fields
in the report (by using OLAP tools, Property Fields) any changes to the order
are ignored by Excel and disappear when the Property fields dialog is
reinvoked.