To build a pivot table to summarize data by month, you can use the date grouping feature. In the example shown, the pivot table is uses the Date field to automatically group sales data by month.
In the pivot table shown, there are three fields, Name, Date,...Read more
This shortcut will select the entire pivot table, excluding report filters.
On Windows, Ctrl Shift * also works to select the entire pivot tableRead more
To build a pivot table that shows latest n values by date, you can add the date as a value field set to show maximum value, then (optionally) add a field as a row column and filter by value to show n values. In the example shown, Date is a value field set to Max, and Sales is a Row field...Read more
In this article, we take a short tour of some "unconventional" pivot tables you probably haven't seen before. These are interesting pivot tables created to analyze something other than sales data.Read more
This shortcut will launch the PivotTable Wizard dialog box.
Note: In Mac 2016, the Pivot Table Wizard appears to be gone....Read more
Pivot tables are an easy way to quickly count values in a data set. In the example shown, a pivot table is used to count the names associated with each color.
The pivot table shown is based on two fields: Name and Color. The Color field is configured as a row field, and...Read more
To list and count the most frequently occurring values in a set of data, you can use a pivot table. In the example shown, the pivot table displays the top Wimbledon men's singles champions...Read more
To extract a list of unique values from a data set, you can use a pivot table. In the example shown, the color field has been added as a row field. The resulting pivot table (in column D) is a one-column list of unique color values.
The data in this pivot tables comes from...Read more