Master dimension based on multiple criteria

[Caroline]

Hi

I need to create a dimension of shared customers across branches.

Clients can belong to one branch only, so they have to be excluded from the result; or to more than 1 branch, and we have to include them. In the example below, I would like the new Master dimension to show Client A and Client C; and exclude Client B

Any idea?

Thank you

[vikasmahajan]

create a master dimension like  attached image also demo attached

Hope this helps you.

Vikas

[Caroline]

Thank you Vikas,

Is there a way you could show a copy of the script? I am a basic cloud user with no ability to install qvf files at the moment.

[vikasmahajan]

you can write simple condition =If(Client <> 'C', Client)