topic Re: Master dimension based on multiple criteria in App Development

Master dimension based on multiple criteria

Caroline — Sat, 16 Nov 2024 06:17:50 GMT

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

Re: Master dimension based on multiple criteria

vikasmahajan — Wed, 20 Mar 2019 08:32:48 GMT

create a master dimension like attached image also demo attached

Hope this helps you.

Vikas

Re: Master dimension based on multiple criteria

Caroline — Wed, 20 Mar 2019 21:45:59 GMT

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.

Re: Master dimension based on multiple criteria

vikasmahajan — Fri, 22 Mar 2019 06:09:55 GMT

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