How to combine elements under single header
Hi all,
I am looking to combine a group of elements (R1, R2, R3) to create element R which I can use in a Discover Matrix Grid. If I add R1, R2, and R3 to a list then my list of elements looks like
P
Q
R1
R2
R3
S
whereas I would like the element list to look like
P
Q
R
S
Additionally, my values in the Matrix Grid are mostly custom measures, so I am hesitant to tackle this problem by creating a lot more. Is there another way to create a list that shows the elements combined under a single label?
Thanks
1 reply
-
You should use a custom measure (or member if it's in a hierarchy) to solve this as you have been doing already. There is usually little or no performance cost to creating, storing or using them.
If you have many and you want to organize them, group your calculations into folders in the content manager (if shared). Alternatively, if you find yourself building numerous one-time items, keep your calculations "un-shared" so they do not clutter up your other reports.
Also: you can create custom measures or members from the element trees (on the left) or via the context menus directly off the grid. Use your mouse and the CTRL button to select multiple elements from the grid. Then right click and choose' quick calcs'.