12 Replies Latest reply: Sep 13, 2013 6:00 AM by jaya prai RSS

    Need to change Expression as Dim

      Hi All,

       

          I am having a requirement,in that I need to convert my Straight Table into Pivot. Issue is earlier  one of the expression which Iused as a expression now  needs to change as Dimension. The expression will be

       

      if(count([Risk Code])>1,concat(distinct [Id],','))

       

      Now I need to use this as a dimension,Due to  some Desgining requirement I need to keep as a second column in the table. So how to perform this calulattion as Calulated Dimension.

       

      Note:

       

         Both fields were available in diffrenet table. So I cant move this into script level.

       

       

      -Jay