4 Replies Latest reply: Apr 17, 2009 7:43 PM by a d RSS

    how can I display sum of rows in the expression

      Salesorder item amount
      121853 10 1
      121853 20 1
      121853 30 1
      121853 40 1
      121853 50 1
      121853 60 1
      121853 70 1
      121853 80 1

      I would like to findout how many items are having the value >=30 the amount should be shown 6

      sumof rows needs to displayed in the expression

      count(if(item >='30',Salesorder))

      sum of row is displaying value

      For reporting

      Salesorder oneitem twoitem morethan3 item

      121853 1 1 6

      I need to display in the chart .

      Advance thanks for your help.