6 Replies Latest reply: Sep 30, 2011 9:04 AM by Julien ROUBERTOU RSS

    Several dimension values belonging in calculated dimension

      Hi all,

       

      Here is the context. I have several projects, associated to a current phase. Each phase belongs to one or two categories, Development or Clinical (Dev_Flag and Cli_Flag). I have this set of data :

       

      ProjectPhaseDev_FlagCli_Flag
      Prj_1Ph_1YN
      Prj_2Ph_2YY
      Prj_3Ph_3NY
      Prj_4Ph_2YY
      Prj_5Ph_1YN

       

      I would like to display on a bar chart, the repartition of my projects by Phase and type of Phase (Development or Clinical). So, I've made a calculated dimension to build my two categories :

       

      =If (Dev_Flag = 'Y', 'Development', If (Cli_Flag = 'Y', 'Clinical'))
      

       

      Problem is that "If" condition is exclusive. Ph_1 and Ph_2 belong to both categories but are displayed only in the first encountered category in "If" Statement. Look at the attached example.

       

      How can I make related projects appear in both category ?

       

      Thanks,

      Julien