Hi, I have created two calculated dimensions called North Agents and South Agents like below.
|North Agents||South Agents|
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.
You have to create a table like this :
The script depends on your data model.
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...
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