SAC Group members in different nodes

[former_member852582]

Hi Experts,

I want to group 4 members in 2 different nodes. Using a hierarchy i am able to group them in just one node. Is there any alternative to group members?

Example:

Member 1

Member 2

Member 3

Member 4

Member 5 = SUM(Member1...Member4)

Member 6 = SUM(Member 3, Member 4)

Using a calculated dimension maybe? But I would have to create it for each model where I use the same hierarchy.

Thanks!

[William_Yu]

You may also use properties(not hierarchy), just show property in the widgets.

[N1kh1l]

jorgeperez2

You can create 2 hierarchies within the dimension. In first hierarchy assign member 5 as parent of member 1 to 4 and in alternate hierarchy assign member 6 as parent of 3 and 4.

Hope this helps !!

Please upvote/accept if this helps you.

Nikhil

[former_member852582]

Hi Nikhil, thank you for your post.

This is the best way to solve it, but by doing this I wouldn't be able to compare Member 5 against Member 6 in the same level.

I would have to use two tables I guess

[N1kh1l]

jorgeperez2

You are right you cannot compare them in same table as they belong to different hierarchy. You can follow attribute based approach as suggested by William but that also will only allow attribute based grouping in one table (won't allow mix and match). Unfortunately the table widget does not allow to select members from different hierarchy at once.

Nikhil