| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Hierarchy Editor"
(→Group Members in Member Selector) |
|||
| Line 61: | Line 61: | ||
[[File:gm1.png|300px|center]] | [[File:gm1.png|300px|center]] | ||
| − | We would like to group all three as one row | + | We would like to group all three as one row so select More and then Group Members from the dropdown: |
[[File:gm2.png|300px|center]] | [[File:gm2.png|300px|center]] | ||
Revision as of 15:13, 3 August 2015
Contents
[hide]Hierarchy Editor
Double-clicking on a Grid's hierarchy label allows you to select the members using the Hierarchy Editor:
The dialog shows the hierarchy and its members. The tree can display either the members directly, or the members grouped by hierarchy level. The Show Levels toolbar button (
) can be used to switch between the two modes:
.png)
.png)
The tree can be expanded to its most detailed level where you can select values such as a specific name of a customer.
To select an item from the tree, either:
- Double click on the item
- Drag and drop the item into the right-hand selection area
To remove an item from the selection area, click on the delete icon at the end of the field. You can also reorder the selected items by dragging the hand icon.
If you have a large hierarchy you can use the Search toolbar field to allow you to search all levels of the hierarchy:
Having built a members list you can save it using the Save button. This can then be loaded into other reports.
Copy Existing Member
New in v8.1 is the ability to copy existing current member selections in Member Selector.
Use the CTRL key & drag icon in red border below:
There are now two entries for United States:
This can be particularly useful in certain scenarios. For example, if you are creating series of in cell charts that are highly-formatted you can format the first chart, copy the existing member selection and then update it to point to another member.
As all the formatting would be in place you will not need to do it all again.
So I have created and formatted an in-cell chart for the United States. I would now like to do the same for another member. Using CTRL and drag I create another entry:
Click highlighted icon to change the member:
You can then pick another member by clicking the drop-down – alternatively you can point to an Excel range.
I am going to pick France – click OK and I now have an entry for an in-cell chart for France as well as United States.
Group Members in Member Selector
New in v8.1 is the ability to group members in the Member Selector. This grouping can be done based on slicer choices. In the screenshot below we have selected France, Germany and the United Kingdom:
We would like to group all three as one row so select More and then Group Members from the dropdown:
The grid now displays one row for the three slicer choices:
Give the slicer a title and it will display that instead of the XL3WithMember as highlighted above.
