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