PivotTables in Microsoft Excel are a great way to get insights from big data sets in just a few seconds. However, most people ...

5. Click OK to see the new grand totaling rows at the bottom of the PivotTable. As you can see in Figure H, the PivotTable has three grand total rows at the bottom.

There are lots of ways to return the top or bottom n records from a data set in Microsoft Excel, but the new dynamic array functions make doing so easier than ever.

Sorting: Right-click on any value within the Pivot Table, then select Sort. You can sort data in ascending or descending order, based on row labels or values.

Field_headers, customizes column and row labels. Row_total_depth, determines the subtotal levels in the rows. 0 or omitted = No totals 1 = Grand totals only 2 = Subtotals and grand totals ...