Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Thant will be helpful man.
Hi,
don´t know if i got your problem right, but this could be a solution.
Hi All,
christian.klinge Solution is working fine..Thank you all and especially christian.klinge
-Jay