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




      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.