11 Replies Latest reply: Jan 26, 2016 11:16 PM by ravikumar Mittapalli RSS

    Sum of one column based on three columns for bar sheet

    ravikumar Mittapalli

      Hi all,

           I have a problem in getting sum of one column which can be loaded in bar sheet depending on other columns...

      For example check the following data:

       

      orderno.hold reasonpricing elemnettotal cost
      co1h1

      mat

      55.5
      co1h1res65.5
      co1h1fp5434.45
      co1h2mat55.5
      co1h2res65.5
      co1h2fp5434.45
      co2h1mat535
      co2h1res853
      co2h1fp3287

       

       

      Now i have given pricing elemnt in X-axis and total cost to be shown  in y axis as per following condition

      MY REQUIRMENT  is for each order no. i want cost for one pricing element  to be taken only once when ur summing it....means mat cost in bar sheet should be 55.5+535...it should not consider the other mat which has holdcode h2.

      Output should be mat -->55.5+535  res --> 65.5+853 and fp should be 5434.45 + 3287..


      I have tried quite alot of ways but couldnt succed...so please help me to solve this,....