Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting Cube dimension names in a Pivot Table
How do I get the dimension names in the "pivot table field list" sorted by
the translated names? The pivot table field list contains: - one measure-node - one dimension node for each cube-dimension. The cube-dimension-nodes are represented by their translated names. It looks like, this names are not sorted by this translated names, but by the order of the data source. The related radio-buttons in the pivot-table-options are greyed ("A to Z" and "sort by data source"). I would need the "A" to "Z" order. Pleas notice! I do not need to sort the pivot data! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - Local Cube - Pivot Table | Excel Discussion (Misc queries) | |||
Unable to display cube calculations in Pivot Table | Excel Discussion (Misc queries) | |||
suppress warning and locate cube in a pivot table from olap cube | Excel Discussion (Misc queries) | |||
Pivot Table - OLAP Cube | Excel Discussion (Misc queries) | |||
Dimension Update and Pivot table report | Excel Discussion (Misc queries) |