There are lots of functions to help me do with if the data was in a single column like [Sales], but the data is spread across 4 columns.
[test 1], [test 2], [test 3], [test 4] I'm trying to throw out the highs and lows of that and then average the remaining two.
You might be able to get what you need by looking over this thread, which highlights the top/bottom N values in each column. http://community.tableau.com/thread/134784
If you can post a packaged workbook (.twbx file) with your data extracted, someone can help you try to set this up.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...