15 Replies Latest reply: Apr 25, 2017 12:28 AM by Rahul Pawar RSS

    how to write expressions

    naveen kumar

      hello,let say i have date like below

       

      supplier        parts            value

      A                  ice                  100

      B                  ice                  200

      C                  ice                  300

      D                  ice                  400

      J                chemical            200

      L                sugar                500

      M                sugar              1000

      ...............................

      ...............................

      .................. so on

      let say i got thousands of supplier

       

       

      i want to display only those parts which  has been supplier by more then one Supplier and i want to show % of that particular supplier among other supplier who supplies same parts.i mean

      supplier          part              value            %of that supplier

      A                  ice                  100                      100/100+200+300+400

      B                  ice                  200                      200/100+200+300+400

      C                  ice                  300                      300/100+200+300+400

      D                  ice                  400                      400/100+200+300+400

      L                sugar                500                        500/1000+500

      M                sugar              1000                      1000/1000+500

       

       

      Note :i dont want to display chemical because it is supplied by only one supplier

      so what expressions do i need write


      I tried this in calculated dimension to display only those parts which has multiple supplier


      1)

      if(count(distinct supplier)>1,part)  (Invalid dimension error)

       

       

      2)%of that supplier

       

      sum(%of that supplier)/sum(total %of that supplier)

      which is also wrong

       

       

      how to write this expressions

       

      Thanks

      Naveen