I'm not sure that this would work since the values can change depending on the time period selected. We are allowing the users to select anywhere from 1 day to the entire data set, so the range will vary greatly.

Seems like this is just not doable in Tableau (yet?). Thank you for the suggestions, though. I really appreciate it. =)