parts which is supplied by multiple vendors

[kunkumnaveen]

Hello All,

can any one help me in finding out what's wrong with my expression,i am trying to display  z-part  spend which has been supplied by multiple vendors.

let say sample data

Z-part    vendor            spend

001          xxx                100

001          yyy                200

001          zzz                300

002          yyy              100

003          kkk                150

003          aaa                  50

what i am trying to display in a straight table is below

Z-part    vendor          sum(spend)

001          xxx                100

001          yyy                200

001          zzz                300

003          kkk                150

003          aaa                  50

only the parts which has been supplied by multiple vendors

Dimension: z-part,vendor

expression:

sum(Aggr(If(Count({<[In Scope]={'Yes'}>}DISTINCT [vendor]) >1,[vendor],Z-part ),spend))

but i am getting Zero as output

any help plz...

Thanks

[fvelascog72]

Hi,

Try this:

Sum( {<[Z-part] = {'=Count(vendor) > 1'}>}spend)

Cheers.

[tresesco]

Try:

Sum({<[Z-part]={"=Count(Distinct vendor)>1"}>}spend)