Glad you got it Jennifer...I was going to suggest a WINDOW_FUNCTION of some type to help you along. They seem to play well with nested table calcs. Don
Thanks Don, and good to know that WINDOW functions are more forgiving in general.
I avoid Table Calcs whenever possible as multiple people handle the workbooks I create and Table Calcs are so easily invalidated by any change to the view. But sometimes they're the right or only way to go!