| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Excel Member Set"
| Line 1: | Line 1: | ||
Creating a member set in Excel allows you to define the members returned on an Axis based on cell contents. | 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 | + | 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 gris layout if required. | ||
[[Image:TupleArrayEditor.png|350px|centre]] | [[Image:TupleArrayEditor.png|350px|centre]] | ||
Revision as of 10:11, 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 gris layout if required.
