Create a new dimension with lesser fields.

[D19PAL]

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

[rubenmarin]

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)