2 Replies Latest reply on Jan 21, 2019 6:10 AM by Per Strid

    Hide column

    Per Strid

      A "standard" issue that I still haven't found out how to solve...

       

      Hide_Column_2019-01-21.png

      I use the standard quick table calculation to get the percent difference between 2018 and 2017. Filter is set to "Last two years" relative to last of december 2018. Years are sorted ascending, so difference is set to calculate relative to last.

      All I want to do is hiding the 2017 column for differences since this will obviously be 0.

       

      Best regards/Pelle

        • 1. Re: Hide column
          Cynthia Derksen

          It's hard to see without a sample.  I could have selected any one of the columns to exclude.  Also, sometimes you need to have a row or column listed for sort or arranging.  To hide that you click on the field in your column or row and right click and unchecked header and it doesn't display the data. I hope this helps.

           

          • 2. Re: Hide column
            Per Strid

            Thanks Cynthia, but this is not what i want to do.

            Since I have two measures, actual and percent difference, and Years as dimensions. If I hide the headers, the years go away for all the columns.

            Hide_Column_2_2019-01-21.png

            If I select hide column all the columns for 2017 goes away.

             

            Hide_Column_3_2019-01-21.png

            The behavior of Tableau seem to be connected to dimensions, not to individual columns...

             

            I attached my file as an example.

             

            Best regards!

            Pelle