5 Replies Latest reply: Jun 22, 2015 1:16 PM by Ramon Covarrubias RSS

    Grouping calculated dimensions

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

       

      North AgentsSouth Agents
      David

      Bob

      StephenJane
      AlexNancy
      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.