ordering child members in a ragged hierarchy -
09-06-2005
, 06:07 PM
We've worked a lot with ragged hierarchies, hiding intermediate levels
with "Hide Member if No Name". Our problem is that the children of
these hidden members are not displayed in the proper order when viewed
as children of a common grand-parent.
Example with a 3-level ragged hierarchy:
Level 1 Level 2 Level 3
Store Type 1
Type 1 L2 A
Type 1 L2 A Store 1
Type 2 L2 A Store 2
Type 1 L2 B
Type 1 L2 B Store 1
Type 1 L2 B Store 2
Store Type 2 (ragged)
Type 2 Store 2
Type 2 Store 1
Note that stores at level 3 are displayed in their proper order when
the intermediate levels (Type 1 L2 A and B)exist.
Store Type 2 contains two separate hidden intermediate levels, so it
appears that the two grandchildren are direct children of Store Type 2.
However the grandchildren do not appear sorted.
QUESTION: Is there any way to keep the grandchildren sorted when the
intermediate level is hidden? |