Looking for more? Try chatting with the Exceljet Chatbot.

Pivot Table

Pivot table list unique values

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.

Data

The data in this pivot tables comes from...Read more

Video

What is a pivot chart

In this video, we'll introduce Pivot Charts. Unlike normal charts, Pivot charts can be used to plot data with hundreds or thousands of rows...Read more
Pivot Table

Pivot table months with no data

By default, a pivot table shows only data items that have data. When a pivot table is set up to show months, this means that months can "disappear" if the source data does not contain data in that month.  In the example shown, a pivot table is used to count the rows by color. There is no data in...Read more

Pivot Table

Pivot table unique count

By default, a Pivot Table will count all records in a data set. To show a unique or distinct count in a pivot table, you must add data to the object model when the pivot table is created. In the example shown, the pivot table displays how many unique colors are sold in...Read more

Pivot Table

Pivot table group by age

Pivot tables have a built-in feature to group numbers into buckets at a given interval. In the example shown, a pivot table is used to group a list of 300 names into age brackets separated by 10 years. This numeric grouping is fully automatic.

Fields

The source data contains...Read more

Pivot Table

Pivot table issue count by priority

Pivot tables have a feature to group dates by year, month, and quarter. In the example shown, a pivot table is used to summarize support issues by month and by priority. Each row in the pivot table lists the count of issues recorded in a given month by priority (A, B, C). The Total columns shows...Read more

Pivot Table

Pivot table display items with no data

When a filter is applied to a Pivot Table, you may see rows or columns disappear. This is because pivot tables, by default, display only items that contain data. In the example shown, a filter has been applied to exclude the East region. Normally the Blue column would disappear, because there...Read more

Pivot Table

Pivot table two-way count

Pivot tables are an easy way to quickly count unique values in a data set, and can easily be adapted to perform a two-way count. In the example shown above, a pivot table is used to count unique combinations of color and size, based on data in the range B5:D16, defined as an...Read more

Pivot Table

Pivot table two-way sum

Pivot tables are an easy way to quickly sum unique values in a data set, and can easily be adapted to perform a two-way sum. In the example shown above, a pivot table is used to sum The Qty field for unique combinations of City and Size, based on data in the range B5:D17, defined as an...Read more

Pivot Table

Pivot table rank example

Pivot tables provide a built-in ranking feature, and can rank smallest to largest or largest to smallest. In the example shown, a pivot table is used to group and rank sales by item. The pivot table is also sorted by rank so that the top sales items appear first.

Fields

...Read more

Pivot Table

Pivot table count by month

Pivot tables have a built-in feature to group dates by year, month, and quarter. In the example shown, a pivot table is used to count colors per month for data that covers a 6-month period. The count displayed represents the number of records per month for each color.

Fields

...Read more

Pages