Thanks Pooja! I thought I had tried that and received the same error before, but it is working!
My new issue is that I need to compute that using "Table (Down)" and it will not let me if I remove Category from the table's display (remove Category from Rows). My final table will only contain 3 rows (MAX, MIN, and AVG) instead of one for per Category.
Yeah table calcs will need the dimensions to be on the view level of detail. However, LOD calcs that were rceently introduced in version 9.0 could make this easier. Which version of Tableau are you using? I am still not too familiar with 9.0, but if you indeed are using 9.0 then I am sure you will get some fabulous answers here from more experienced users
I am using Version 9 but have not explored the new features myself. For now I am offering the user a Box and Whisker plot because that offers the Min/Max values the way they should be visualized.
Thanks again for all the help!