Select the Member Selector tab to modify the members used in a dynamic chart.
Add members
- Within the Layout option, select the Member Selector tab.
- From the hierarchy dropdown, select a hierarchy.
- Drag and drop members to the Selection section on the Members tab.
- Select the ellipses next to the member in the Selections tab and choose an option:
| Option | Description |
| The member selected | The specific member that is currently selected for the dimension. |
| Children | The direct sub-members of the selected member. |
| Descendants | All the sub-members of the selected member, at any level of the hierarchy. |
| Lowest Descendants | The leaf or lowest-level members in the hierarchy that are descendants of the selected member. |
| Descendants Between | A range of descendants, specified by a start and end point within the hierarchy. |
| Next | The number or range of the next members to be used. |
| Previous | The number or range of the previous members to be used. |
| In-Cell Chart | Displays a small chart (sparkline) within the cell of the selected member. |
| More | Additional selection criteria: |
| - First child | Selects the first direct child of the selected member. |
| - Last child | Selects the last direct child of the selected member. |
| - Same Level | Selects members that are at the same level in the hierarchy as the selected member. |
| - Siblings | Selects all members that are at the same level and have the same parent as the selected member. |
| - Parent | Selects the immediate parent of the selected member. |
| - Ancestors | Selects all the parent members of the selected member, up to the top level of the hierarchy. |
| - First Sibling | Selects the first sibling of the selected member, which is the first member at the same level with the same parent. |
| Delete | Delete the member from the Selections section. |
- Select the Advanced or Member Selector tab.
- Select the Aggregate dropdown and choose from the options below:
| Option | Description |
| Sum | Calculates the sum of all values. |
| Average | Calculates the average of all values. |
| Minimum | Returns the minimum value. |
| Maximum | Returns the maximum value. |
- Select the ellipses next to Members or Default Member and choose from the options below.
This dropdown presents a list of actions that you can perform after an aggregation (or other data manipulation) is complete. The purpose of these actions is to further refine or process the results of the aggregation.
| Option | Description |
| Rank result | Orders the members based on a specified metric. The order of display is then rearranged. |
| Filter result | Allows you to include only certain members based on criteria you set. This filters the visible members. |
| Sort result | Sorts the members alphabetically (ascending or descending) or by another criterion. |
| Member search | Enables swift location of specific members through a search query. |
| Outlier Grouping | Enables you to group members based on their deviation from the average or other statistical measure. |
| Subset | Creates a subset or filtered view of the members. The original members remain, and a new selection is created. |
| NonEmpty | Displays only those members with non-zero values. |
| Exists | Displays solely those members with associated data, which may differ from NonEmpty based on the intricacies of your data structure. |
| Distinct | Eliminates any duplicate members from the selection. |
| Aggregate Members | Enables you to aggregate selected members into a single summary. |
| Edit | Enables the modification of the selected member(s) properties. |
| Remove item | Deletes the selected member(s). This action is irreversible. |
After selecting the options, select Apply.
Next to the Aggregate dropdown, are three icons:
- Hide levels - hides hierarchical levels.
- Import using query - import members using a Multidimensional Expression (MDX) query from selected members on columns.
- Add - Apply one of the actions listed in the above table that can further refine the results. Or select an option under the Add new section, which opens a new window for adding new members to the chart:
| Option | Description |
| Member list | Add a dataset via a list of members. |
| Member set | Add a set of members by defining a set based on a range or write an MDX expression. |
| Default Member | Adds the default member. |
| All Hierarchy Members | Adds all members within a hierarchical structure. |
Select a range within the Excel sheet to populate a chart. Create a slicer to modify the chart based on a selected member.
