This content has been marked as final. Show 5 replies
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.