Add Rank to PivotTable

Today’s author is Mike Alexander, a Microsoft Excel MVP who shows us how to add a rank to a PivotTable in Excel 2003, 2007, and 2010. For more information, visit www.datapigtechnologies.com . Adding Rank in Excel 2003/2007 Step 1: Sort your pivot table on the data measure you are trying to rank. Step 2: Add a Calculated Field that will have the formula =1 . This will essentially assign a value of 1 to each row. Step 3: Right-click on your newly created calculated field and go into its Value...(read more)