How to rank with a pivot table

Pivot Tables make it incredibly easy to analyze data quickly without formulas. In the example, we use a pivot table to summarize product sales by product, then assign a rank to each product in the list. This is something you can do in less than a minute.