Grouping calculated dimensions

[#1]

Hi, I have created two calculated dimensions called North Agents and South Agents like below.

North Agents	South Agents
David	Bob
Stephen	Jane
Alex	Nancy
	Jake

I want to create a new dimension called North South Agents including the North Agents and South Agents grouping. So the drill down would be like North South Agents -> North Agents & South Agents -> Bob, Jane, Nancy, Jake, David, Stephen, Alex.

Is there anyway I can do this? I would appreciate any answers. Front end calculated dimension is preferred but scripting is also very appreciated.

Thank you.

[#2]

Hi,

You have to create a table like this :

Agent	Group	SubGroup
David	North South	North
Stephen	North South	North
Alex	North South	North
Bob	North South	South
Jane	North South	South
Nancy	North South	South
Jake	North South	South

The script depends on your data model.

Regards;

Xavier.

[#3]

Hi Xavier, is there a way to do this on the front end using set analysis and conditional statements?

[ramoncova06]

you need to create a calculated dimension like this

if(Agent = 'David' or Agent = 'Stephen' or Agent = 'Alex', 'North', 'South')

[#5]

Thanks. It's a really tedious process because in the real data I have like 40 text values for conditions and in other datasets the number of conditions go up to +200. Thumb up but I'd appreciate it if there is an easier way to do this...

[ramoncova06]

you could always try with an applymap but that would be a backend script change, if you have another way to identify that is not at that granular level, you might be able to do a front end expression