Grouping

[moonknightt]

I am using BO 6.5

I need to combine or group numbers 1- 20 by 2
for example

1 and 2 = one group
3,4 = one group
5,6 = oe group
7,8 = one group etc

Any help will be appreciated

 

[blom0344]

There is more than one solution, but for this BO offers the grouping variable. Select the dimension you want to group and then apply a group on it.

You can achieve this as well with a long IF ... THEN ... ELSE definition..

Ties Blom

 

[skrandel]

Better yet, grouping like this is best done at the universe level with a CASE statement.

Steve Krandel
Symantec