Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
The expression is for a dimension. There is a list box which the user selects his desired Dimension. I didn't know else to get the dimension to change according to this list box.
=if([Dimension 1]='Campaign', Campaign,
if([Dimension 1]='Date', Date,
if([Dimension 1]='Department Name', [Department Name],
if([Dimension 1]='Domain', Domain,
if([Dimension 1]='Market', Market,
if([Dimension 1]='Weekday', WeekDay, Null()
))))))
Maybe like
=$(=only([Dimension 1]))