Create (master)dimension based on other dimensions

[Anonymous]

Hello,

I'd like to create a (master)dimension based on two other fields.

ID group	ID function	ID
A	ABC	1
A	ABC	2
A	PMO	3
A	PMO	4
B	BFG	5
B	BFG	6
B	KJT	7
B	KJT	8

=> create field ID-ADC where I only have the ID's for ID group "A" but excluding the "ID function" PMO

Thanks in advance!

[aarkay29 · Accepted solution]

May be this

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