3 Replies Latest reply on Aug 14, 2018 1:41 PM by Bryan Pon

    Counting instances of dimension, given another dimension is true

    Bryan Pon

      I think a simple question but I can't find an answer in the forums...

       

      Easiest to describe in terms of Superstore data:

       

      I want to create a calculated field that includes all the customers who bought chairs.  

       

      So I can count instances of [Order ID]>0, but I need to restrict that to only counting [Order ID]>0 when Sub-Category = "Chairs" ....not sure how to add that condition into the calculated field.

       

      Thanks!

      Bryan