Pivot table ranking function always return "1" when using two rows

Hi There,   I have created a pivot table using data pulled from a data model consisting of two different tables.  It's basically a report that list customer names and their sales for different prod...