Excel 2007 Pivottable Rank

P

peter

Is there a way with pivottable in Excel 2007 to add the rank within each
group? I have table with location and products going down and Dollars and
Units across the top. I would like to add a fact that show the rank for the
products within the location.
 
Top