2 Replies Latest reply: Jul 3, 2017 4:25 AM by Tresesco B RSS

    parts which is supplied by multiple vendors

    naveen kumar

      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