Please kindly assist me , how can I indicate correctly on my chart

[suvechha_b]

Hi All ,

Please kindly assist me , how can I achieve the below on my chart ,

For eg ,

if bank ='MFC' and ApprovedReceived_Deal_Indicator='1' then it should indicate 'A' else 'D' inrespective if deal_id .

sample model attached.

[Frank_Hartmann]

i guess you need to add deal_id as dimension in your second table

hope this helps

[suvechha_b]

Thanks Frank .

But , I don't want to add the deal_id .

Is there no other way to get my requirement , as my requirement is per client not on per deal_id .

[Frank_Hartmann]

=aggr(if(bank='Wesbank' or bank='MFC' and ApprovedReceived_Deal_Indicator ='1','A','D'),deal_id)