Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Real easy one that I forgot how to do.
I got a dimension with values
A,
B,
C,
D
As dim1
And that's how it shows in a table.
I want to create dim2 and drop in table and only show
A,
B
Thanks
Hi, you can crete an additionalfield on script with just those values, in the same table where dim1 is loaded you can add:
If(Match(Dim1Field,'Value1','Value2',...), Dim1Field) as Dim2Field
If you want selctions in only the Dim1field you can use a calulated dimension like: Aggr(If(Match(Dim1Field,'Value1','Value2',...), Dim1Field), Dim1Field)