2 Replies Latest reply on Oct 12, 2018 3:43 AM by Suvi Ahlstedt

    Count of records with condition

    Suvi Ahlstedt

      Hi,

      I´m quite new to Tableau and I´m trying to solve following problem and currently have no idea how to proceed.

      I should get count of orders which contains two specific products, for example count of orders which includes both Juice and Lemonade (it doesn´t matter if order includes also something else but those two are required to include to same order).

      Below is sample data and correct answer should be 2 (Orders 1 and 3) but how I can calculate similar in Tableau? Orders may have x rows with different products but only the combination of two specific products is desired.

      My data is quite big and I have to use another dimension but order as row dimension.

       

      OrderRowProduct
      11Milk
      2Juice
      3Lemonade
      21Milk
      2Lemonade
      31Juice
      2Lemonade
      41Milk
      2Lemonade
      51Milk
      2Juice

       

      Thank you in advance!