Need to change Expression as Dim

[#1]

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

[sujeetsingh]

Thant will be helpful man.

[sky · Accepted solution]

Hi,
don´t know if i got your problem right, but this could be a solution.

[#4]

Hi All,

   christian.klinge Solution is working fine..Thank you all and especially christian.klinge

-Jay