Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have grouped values into subgrups with if statement and created dimension out of it in order to sort sheet values.
Expression = If(WildMatch(Field, 'a*', 'b*'), 'Group1') , name of Dimension = Groups
However , as I add the dimension to the filer chart, subgroups as 'Group1' are displayed correctly, but name of field ' Group' is not visible. I have tried to fix it by changing names , but without any success. Did any of you encounter similar issues?
Am i right, that you created this group dimension in the master items? Then your dimension is just a culculated dimension. It is better (speaking in terms of performance) to define such dimensions in the script and make it a real dimension. As a side-effect the dimension name would be shown correctly as well.
Am i right, that you created this group dimension in the master items? Then your dimension is just a culculated dimension. It is better (speaking in terms of performance) to define such dimensions in the script and make it a real dimension. As a side-effect the dimension name would be shown correctly as well.