Master dimension based on multiple criteria

Caroline · ‎2019-03-19

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 · ‎2019-03-20

create a master dimension like attached image also demo attached

Hope this helps you.

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Caroline · ‎2019-03-20

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 · ‎2019-03-22

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

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

expression

Master Items