Is there a way to include a ranking within a Pivottable in Excel 2007?

I have used =RANK(H6,H$6:H$77) used this outside of the table for now, so I
do get the correct number, but if I collapse the table, of course I get #N/A.
If the data is updated and I have more rows, then I will need to update the
formula.

I can at least sort them to see which was the best and which was the worst,
but not able to see (without manually coutning) which is #10, #15, etc.

Any help would be greatly appreciated and I will use RANK forumal in the
meantime.
--
Peter