Distinct count In a pivot table- Excel for Mac 2016
First, I can't create the pivot table using a data model like I could previously, or don't know how to access that in this newer version but is there any way to still get a distinct count in the pivot table?
This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread.
You can accomplish the same thing as the data model by manually performing the steps that the data model does for you. The data model uses a SQL query to build an intermediate table from which the final result set is obtained. You can query your data source
with a SQL statement having DISTINCT or DISTINCTROW to build an intermediate table from which you can make your PivotTable.
I am an unpaid volunteer and do not work for Microsoft. "Independent Advisors" work for contractors hired by Microsoft. "Microsoft Agents" work for Microsoft Support.
7 people were helped by this reply
Did this solve your problem?
Sorry this didn't help.
Great! Thanks for marking this as the answer.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.