Welcome to the forums! Not sure I completely understand the question. Would you be able to post a screenshot or packaged workbook with an explanation of what exactly you'd like to see?
1 of 1 people found this helpful
Kevin: I did take a look at your workbook. You are using Measure Names/Measure Values, so I'm not sure how to help in your situation. If you had a Dimension called "Sport" with the various sports as members, and just one column to hold the "value", this would be much simpler to do--then, you'd simply filter for "value" of greater than 0.
I assume you don't want to re-shape your data. Maybe someone else will step in and provide you with the answer. Sorry I can't be of more help; there still may be a very simple solution but I don't know what it is off the top of my head.
If there were a way to use measure names/measure values inside calculations, that might also solve your problem--but alas, we cannot. Might want to vote for ideas like: http://community.tableau.com/ideas/1256 and http://community.tableau.com/ideas/1071