Filter memberset by properties, how to get Parent member at bottom
I filtering an expansion member set by 2 Properties. Is there a way to get the Parent member to appear at the bottom of the retrieved list.
The member set formula I tried unsuccessfully is:
ARR_ITEM="Y" AND ARR_PAGE="MKT", SELF
The Parent member appears at the top and bottom of the retrieved list. Am I missing something?
David Fletcher replied
You are not doing a hierarchical expansion, (MEMBERS, ALL, DEP) therefore parent members do not come into play. The members are displayed based on the order they exist in the dimension, (usually).
u201CPARENTAFTERu201D applies when you are expanding based on a hierarchy.
u201CSELFu201D applies to the dimension member selected in the current view or coded elsewhere, like the u201CPageKeyRangeu201D
One approach is to have a property to filter on and the values in the property would be a numeric value, (i.e., 100 u2013 999) defining the presentation order of the members. You can then filter on the property, (i.e., property<>u201Du201D) display the property values using evpro and then sort the rows.
You can use the u201CAFTERRANGEu201D to provide a total.