ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel Pivot Table, Property Fields (https://www.excelbanter.com/excel-discussion-misc-queries/132513-excel-pivot-table-property-fields.html)

Jim Plant

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.


All times are GMT +1. The time now is 06:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com