Listbox with selected and excluded values

[j_nlucas]

Hello,

I've got the following scenario:

- 1 table for area managers linked to fact table through IdManager

- 1 table for customers linked to fact table through IdClient

- 1 field Idmanager2 in the Customers table

When a area manager is selected, this will give me a list of customers that come from the relationship with the manager. These are the possible customers.

But from the list of excluded customers, there are some with the same IdManager in the field IdManager2, that I also want to show.

So, what I am trying to put together in a list box (or as dimension in a table)

- All the possible customers

- All the excluded customers with the Idmanager selected in their IdManager2 field

My approach is this:

CONCAT({<CLIENTE=P(CLIENTE)>}IdCustomer,',')     --> List of selected customers (linked to the IdManager). This half works.

& 

CONCAT({<CLI_FIGURARESP=E(IdArea_manager)>}CLIENTE,',')  --> List of customers with the IdManager on the table. It's not working

Datamodel attached.

Table FIGURA is for Area managers. Fields FIGURA and IdManager are the same

Table Cliente is for customers. CLI_FIGURARESP is the IdManager

Any idea?

Thank you

Joaquin

[YoussefBelloum]

Hi,

would you be able to attach sample data from each table and describe the exptected output ?

[j_nlucas]

Hi Youseff thanks for your quick reply. I just updated the post and uploaded the data model. Maybe that will help.

[YoussefBelloum]

if you're using listboxes, concat will not work, you will need to use only with aggr(), like this:

let's look at the first one :

=Aggr(only({<CLIENTE=P(CLIENTE)>}IdCustomer),IdCustomer)

[Digvijay_Singh]

May be this -

Aggr(only({<CLIENTE=P(CLIENTE)>+<CLI_FIGURARESP=E(IdArea_manager)>}IdCustomer),IdCustomer)

[j_nlucas]

Hi Digvijay,

Unfortunately that doesn't show the extra idCustomers