6 Replies Latest reply on Nov 20, 2018 8:35 AM by Joe Oppelt

    Compare within same dimension

    Nasir Khan

      Hello beautiful Tableau community,

       

      I have a request to compare several items to each other. This can be a 1 to 1 comparison or many to many or 1 to many. I want something like this:

       

      I want to have 2 filters. Both filters will have the same items. I have the ability to manipulate the data if need be. in the above example I just have a simple example; in my actual dashboard I will have many measures and a timeline as well. The data so far looks something like this:

       

       

      GroupItemSales
      A15
      A26
      A39
      A15
      A27
      A32
      A167
      A212
      A311
      B15
      B211
      B366
      B18
      B24
      B335
      B184
      B225
      B321

       

      I need the filters to be independent of each other. Which is the easy part. How do I get the difference accomplished? I can use a separate sheet or formula.