How to dynamically show data when only one column data changes?

[Anonymous]

I have the following visual table being created in one of my reports.

Name	# of Cases	# of Units
Customer1	1	300
Customer2	1	300
Customer3	1	300
Customer4	1	300
Customer5	1	300
Customer6		300
Customer7		300
Customer8		300

I only want to show the Name and # of Units when there is a value in # of Cases.  For this visual, the # of Units doesn't matter to the users unless there is a value in # of Cases.  The data being populated is coming from 3 seperate tables for each respective column.  So, I'd expect the table to look like the following given the data above..

Name	# of Cases	# of Units
Customer1	1	300
Customer2	1	300
Customer3	1	300
Customer4	1	300
Customer5	1	300

Any easy tricks for this?

[Anonymous · Accepted solution]

Sorry. I should have seen this - I just need a Visual Filter for that field that is set to Show items when the value: "is not blank"

Doh!