Set up by default variable

[Anonymous]

Hi guys,

I have a table with 2 dimensions with conditions like below

=SubStringCount(Concat(Fields, '|'), 'Channel')

and variable where I select my field "Channel" or "Campaign"

I'd like to set up by default "Channel" field and never show 2 dimensions at the same time.

Please see my attached file.

Thanks,

[jerem1234]

You can remove your dimensions and add something like:

=$(=Fields)

as a calculated dimension.

This will return whatever you select and use that as dimension. However you will need to make sure that they only select 1 value at a time. You can do that by adding a listbox with your Fields field, and then check "Always one selected value". If you want Channel as default, just make sure you have that clicked when you save document.

Please find attached.

Hope this helps!