Home » Education » 2 Quick Ways To Calculate Distinct Count With Pivot Tables

2 Quick Ways To Calculate Distinct Count With Pivot Tables

Written By Excel Campus - Jon on Thursday, Sep 10, 2020 | 07:00 AM

 
Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/ In this video, you can see two different ways to calculate distinct count in a data set using Pivot Tables. These are two solutions to a Data Analysis Challenge that I gave to viewers. You can download the example Excel files and read the full article here: https://www.excelcampus.com/pivot-tables/distinctcount-pivot-tables. Related Videos: Excel Data Analysis Challenge - Count Transactions with Multiple Rows: https://www.youtube.com/watch?v=_3lX1NwIfzQ Introduction to Pivot Tables, Charts, and Dashboards in Excel: https://www.youtube.com/watch?v=9NUjHBNWe9M&t=5s Refresh Pivot Table Automatically when Source Data Changes: https://www.youtube.com/watch?v=NI1UQcYtl1A 5 Reasons to Use an Excel Table as the Source of a Pivot Table: https://www.excelcampus.com/tables/table-source-pivot-table/ #MsExcel #ExcelCampus 00:00 Introduction 00:50 Pivot Table Solution 05:33 Power Pivot Solution

Disclaimer:
All images, musics and videos copyright are belong to their respective owners. We just put embed contents from Youtube.com and do not host any content in our server. These content(s) may be protected by copyright law or other laws regarding intellectual property of the United States or other countries. Downloading file(s) on this site is just for review purpose. If you love the song, please support the artists by buying the original CD/Cassette or buying the song from iTunes.