1 2 3 Previous Next 38 Replies Latest reply on Apr 28, 2016 10:33 PM by Shivang Desai

    Getting total sales in tableau for all order numbers that have order number same as beverages

    Shivang Desai
      Hi All,

       

      I am a bit stuck in getting a particular scenario for Tableau.

       

       

      I am trying to get total sales for a particular sales order which includes only beverages.

       

       

      Example: Salesorder#1: Beverages - 5$

                                            Chicken - 10$

       

      Salesorder#2: Chicken - 12$

                           Chips - 8$

       

      Salesorder#3: Deserts - 4$

                             Beverages - 6$

       

       

      I just need sum of total which has beverages in it. So, as per above examples, I should get Total = 25$ i.e. (Beverages + Chicken = 15$) and (Deserts+ Beverages = 10$) and it should not include the salesorder2.

       

      How can I achieve this in Tableau?

       

      Also an extension top this is getting all by a store name?

       

      Kind Regards

       

        1 2 3 Previous Next