2 Replies Latest reply on Sep 15, 2018 2:01 PM by Shinichiro Murakami

    Filter Table, but keep one column constant

    Kamil Nikiel

      Hi,above

       

      I got puzzled with filtering of my table in Tableau...I got data looking like:

       

      Month Group
      Period 0Period1Period2Diff (Period 0- Period 1)
      April5233
      May10466
      June15788

       

       

       

      I Want to be able to filter on "Period" but the trick is that I do not want Period 0 to be available on a list, and I want it to be constant and always visible on my worksheet. I want filter to Show columns for Period 0 and Period 1 , or Period 0 and Period 2. So the "Diff" column would calculate using period 1 or 2
      Any idea how to achieve it?