I'd like to create a (master)dimension based on two other fields.
=> create field ID-ADC where I only have the ID's for ID group "A" but excluding the "ID function" PMO
Thanks in advance!
May be this
If([ID group] = 'A' AND Not Match([ID function],'PMO'), [ID group] &'|'& [ID function]) as MasterDimension
Retrieving data ...