| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Excel Member Set"
(Created page with "d") |
|||
| Line 1: | Line 1: | ||
| − | + | 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 whihc is the standard behaviour | ||
| + | |||
| + | [[Image:TupleArrayEditor.png|350px|centre]] | ||
Revision as of 10:08, 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 whihc is the standard behaviour
