How to group variables

building reports webintelligence
1

Good morning,

I need help with one variable. I have one variable calle [group] which has inside from Group A to Group H.

However, I need to create a variable called [area] which is the sum of these groups. For example, Area 1= Group A+B+C, Area 2= Group D+E+F… So, in [area] I will have area 1, 2…

Is there a way to group in only one variable these requirements or should we do it in the universe builder?

Thanks a lot

jaylagas2 (BOB member since 2013-09-25)

2

Hi,

You can create a report variable with a syntax similar to this one:

=If [group] InList ("Group A";"Group B";"Group C") Then "Area 1" Else If [group] InList ("Group D";"Group E";"Group F") Then "Area 2"

and then use this dimension along with a measure.

Marek Chladny :slovakia: (BOB member since 2003-11-27)