You haven't given us anywhere near enough to help you work this out, especially since it involved Tablea Calcs. So you're really going to have to sanitize your data and post a packaged workbook.
Sorry I never got back to you on this one.
My fellow co-worker Prashanth Sundaravadivelu posted a question pursuing the same expected behaviour out of tableau.
This level of TB understanding is definitely helping us out!!!
Good to hear. And a good demonstration of how much better quality answer you get when posting a package workbook. Mark your reply correct. Or delete this altogether.