Pivot table: Distinct count in Excel 2013 and 2016

[Amadeus]

In Excel 2013 and 2016 there is the option to select "Add this data to the Data Model" when creating a Pivot Table. This will allow for summarize values by "distinct count" (finally!)

I did not check the box when I made my Pivot Tables. However, I need the "distinct count" function and I do not have the time to create all the tables again.

Anyone that know how to be able to use "distinct count" in a Pivot Table when "Add this data to the Data Model" was not checked during the creation?

 

[sijpie]

Adding data to the datamodel normally goes through the pivot tables. If you have the Professional edition or full 365 then you will have the Power Pivot add-in. Maybe you need to enable it first.

With this add-in you can add and manage your data model. See also:
https://support.office.com/en-us/ar...in-Excel-87e7a54c-87dc-488e-9410-5c75dbcb0f7b

You can also add data to the datamodel in a different way. The data needs to be in an Excel Table. When you set up a connection to the table, you can add the table to the data model. See this video explaining how:
https://www.youtube.com/watch?v=kf2rO-CPM04