6 Replies Latest reply: Oct 27, 2015 3:17 AM by raman rastogi RSS

    how to calculate sales volume in the province

    li ming

      Hi,

       

      I'm trying to calculate the sales volume in the province.the data sources example in the following

       

      D@provinceC@provinceQty
      AA

      100

      AB200
      AC300
      BB400
      BD500
      BC600

       

      now, I want the result is

      sum(D@province=A)=100  where C@province=D@province

      sum(D@province=B)=400  where C@province=D@province

       

      how to write the expression?

      =sum({<   >}Qty)

       

      THANKS ALL!