1 2 Previous Next 19 Replies Latest reply on May 3, 2016 4:49 PM by Shivang Desai

    how to get total of sales order having just beverages in it?

    Shivang Desai

      Hi All,


      I am not getting the query to get total sales order whose id is same as that of beverages.



      Salesorder#1: beverages 10$

                    chips 5$


      Salesorder#2: chicken 5$

                    chips 8$



      Salesorder#3: beverages 4$

                    chicken 6$



      So as per the above example, I should get the sum as 20$
      (salesorder#1 + salesorder#2)


      When I goto Analysis and select grand total it gives me all the total order sales (ex: salesorder#1 + salesorder#2 + salesorder#3).


      Please help me with this?


      Kind Regards,

      Shivang Desai

        1 2 Previous Next