2 Replies Latest reply on Mar 31, 2014 8:58 AM by john.finn

    Display only Non Null data based on two calculated fields

    john.finn

      Hi,

      I am searching for a technique that would allow me to hide (or not display) certain Dimensions based on two or more measures (calculated fields) being NULL. I have attached a packaged workbook.

       

      My Dimensions are displayed as a Hierarchy to allow users to drill into the data. The data is designed to show Qty Sold and Sales Value for selected date range and selected date range minus one year. For this purpose I am using calculated fields as per discussion Show sales for selected date range and selected... | Tableau Support Community.

       

      I have now been set the challenge of hiding those FIRMNAME rows where Qty TY and Qty LY are both null for any selected date range.

       

      Hopefully someone can assist me with this one. In the meantime I will keep searching...

       

      Thanks,

       

      John.