Highlighting the top or bottom values in a PivotTable


show more Highlighting the top or bottom values in a PivotTable provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth show less
please wait ...

Highlighting the top or bottom values in a PivotTable

Companies of all kinds are interested in their best salespeople, their best customers, and their best-selling products. Excel enables you to create what are called Top 10 conditional formats to identify the top or bottom values in a PivotTable. You can create two types of Top 10 conditional formats in Excel, formats that identify a certain number of top or bottom values or a format that identifies the top or bottom values based on the percentage. For example, if you wanted to identify the top 10% of your customers by sales regardless of the total number of customers, you could create a percentage based format.

In this case, I have monthly revenue data from two companies, FirmA and FirmB, and what I'd like to do is identify the top seven values within the PivotTable. In other words, I don't want to look at totals or grand totals or subtotals; instead, I want to look at individual months. To create that Top 10 conditional format I'll click any cell in the data area and then on ...

Highlighting the top or bottom values in a PivotTable
Video duration: 3m 30s 3h 43m Intermediate

Viewers:

Highlighting the top or bottom values in a PivotTable provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth

Subject:
Business
Software:
Excel
Author:
please wait ...