This Excel tutorial explains how to use distinct count in Pivot Table to count number of unique value in a column grouped by other fields.
Excel Pivot Table Distinct Count to count unique data
In Excel 2013, there is a new aggregate function in Pivot Table called Distinct Count, which counts number of unique value in a column. For example, if a column contains employee names, you can use the distinct count function to count number of unique employee names in the column such as below.
In thi...
Read More
Chapter 5 – Pivot Table
Group Date and Ungroup Month in Excel Pivot Table
This Excel tutorial explains how to group dates and ungroup month in Excel Pivot Table to prevent auto grouping of Pivot Table in Excel 2016.
Group Date and Ungroup Month in Excel Pivot Table
Since Excel 2016, when you drag a date field to a Pivot Table Pivot Table Row, the dates are automatically grouped by months instead of showing each date. This is extremely annoying because it is tricky to ungroup the months if it is the first time you encounter this issue.
In this post I am going t...
Read More