expression for the following scenario

[#1]

I need to get the same supplier group for the common Global supplier id

Gloabal supplier id  , ncr,         scar,      partnumber ,           supplier group

ew-000891              234            145          ahaas652            CMDS

ew-000891               12                3          fa                         -

ew-000891                 -              -                -                       -

Please find screen shot.

For that same global supplier id i need to CMDS as supplier group for the remaining two records

[Anonymous]

Hi

How about first doing a mapping load :

SupplierGroupMap :

Mapping Load distinct

[Gloabal supplier id] ,

[supplier group]

from ............ your datasource

;

Then when you load your real data something like :

Load

ApplyMap ( 'SupplierGroupMap' , [Gloabal supplier id] )     as [Supplier Group from AppyMap] ,

*

from ............ your datasource

;

Best Regards,     Bill

[#3]

Need to do on UI

[Anonymous]

Why ?

[#5]

I cant change the script now i can only have expression for that..

Thanks in advance

[Colin-Albert]

Bill's answer is correct. Don't try and fix an incorrect data model by bodging the chart. Get the correct data model and the chart is simple.

[maxgro · Accepted solution]

try this

MaxString(TOTAL <[Gloabal supplier id]> [supplier group])

[Anonymous]

write a calculated dimension instead,

= if(Global supplier id= 'ew-000891', 'CMDS', ' ' )

[#9]

thanks, i have many global supplier id's .That's the issue

[preminqlik]

here u go :

MaxString(TOTAL <[Gloabal supplier id]> [supplier group])