3 Replies Latest reply on Dec 8, 2012 9:55 AM by Damian Jordan

    how to show this table that includes missing values (indicated by 0s) the way I wanted after applying a filter

    Xiaorong Li

      Hi guys,

       

      I have a question about how to show the following table that includes missing values (indicated by 0s) the way I wanted after applying a filter.

       

      My current problem is: after I apply the filter to only show 'Acer' (for example), the table will then only show me the result for year 2009, because that's the year that actually has a non-zero value. But what I want is to still show 0s from all other years (meaning I still want all other years to display in my row header). Is it possible at all in Tableau to achieve that?

       

      I have pasted two screen-shots below to explain what the problem is. So in the first table, I have 0s for all those years that have missing values (now replaced by 0s). The second table shows the result when I apply the 'system manufacturer' filter to only show 'Acer'.

      Thanks so much!

       

      Xiaorong