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.

       

      Example:

      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