Show Distinct Count in Excel Pivot Table with PowerPivot - vTomb

Show Distinct Count in Excel Pivot Table with PowerPivot

Home
Donate
All
People & Blogs
Entertainment
Music
Gaming
Education
Howto & Style
News & Politics
Science & Technology
Film & Animation
Sports
Comedy
Autos & Vehicles
Nonprofits & Activism
Travel & Events
Pets & Animals

http://www.contextures.com/xlPivot07.html#videodistinct Visit this page to download the sample file with the sales data.

A normal pivot table in Excel can't create a unique count (distinct count) for a field. However, if you have the PowerPivot add-in installed, you can use its DISTINCTCOUNT function.

In this video, you'll see how to connect to an Excel file that contains the data, build a pivot table, and show a distinct count.

By using our services, you agree to our Privacy Policy.
Powered by Wildsbet.

© 2021 vTomb

By using our services, you agree to our Privacy Policy.
Got it