| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Excel Member Set"
| Line 5: | Line 5: | ||
You can leave a cell blank to get the default member of a hierarchy. | You can leave a cell blank to get the default member of a hierarchy. | ||
| − | You must define the hierachies as well as the members, and this allows formulae to update the | + | You must define the hierachies as well as the members, and this allows formulae to update the grids layout if required. |
[[Image:TupleArrayEditor.png|350px|centre]] | [[Image:TupleArrayEditor.png|350px|centre]] | ||
Revision as of 12:05, 23 August 2021
Creating a member set in Excel allows you to define the members returned on an Axis based on cell contents.
This can offer more flexibility that defining the members for a hierarchy in Excel, as it allows you to chose which combinations of members are displayed instead of the grid doing a crossjoin which is the standard behaviour.
You can leave a cell blank to get the default member of a hierarchy.
You must define the hierachies as well as the members, and this allows formulae to update the grids layout if required.
