Excel Pivot Table Distinct Count to count unique value

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

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