3 Replies Latest reply on Jan 11, 2019 11:14 AM by pavan hm

    count of a grouped dimension?

    gerardo.modesto

      Hello all,

       

      I'm fairly new to tableau and I'm having the following issue. Below is a sample of the data I'm using.

       

      Customer No.Item
      1A
      1B
      2A
      3A
      4A
      4B
      5B
      6A

       

       

      This is the result I'm trying to get:

       

      ItemTotal Count
      A5
      B3
      A and B2

       

      I'm trying to get a count of how many customers bought Item A and B. So far I tried doing a separate group by combining A and B but I get the total result of 8. I also tried doing a calculation and I'm getting the same result. Can someone please point me to the right direction on how to get this result. Thanks!