On a sheet in my dashboard, I have a straight table and two filters. The two filters are: Year and Relationship Status. The straight table has: Test and Test Status. When I selected the Relationship Status filter, I want my straight table to adjust accordingly, just like it normally would. However, when I select the Year filter, I need all the values in the straight table to stay visible, even if the information doesn't pertain to the selected year. It would be nice if the Tests always stayed in the table and the Test Status field showed a zero and just showed as null.
