Create (master)dimension based on other dimensions

Anonymous — Thu, 23 Mar 2017 12:31:28 GMT

Hello,

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!

Re: Create (master)dimension based on other dimensions

aarkay29 — Thu, 23 Mar 2017 13:19:33 GMT

May be this

If([ID group] = 'A' AND Not Match([ID function],'PMO'), [ID group] &'|'& [ID function]) as MasterDimension