The problem you're running in to is with the point in the process where summary data is evaluated and frustrated me for a long time (still does). The reason your formula isn't showing up is due to the fact that it hasn't been evaluated at that point. About the only work-around I know of would be to create a manual crosstab instead of inserting a cross tab which should do what you want. Having only been on Tek-Tips for a short time, however, I can assure you there's more help on the way from the experts!!