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.




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