I'm using 2013, and need to use the count function in the pivot table. However I need it to be a distinct/unique count versus a count of every row. I've read somewhere else that in order to do this, I can hit the check box "add this data to the data model" during the first step of creating a pivot table, and this will enable me to create the distinct count. I see where the checkbox is, however it's grayed out and doesn't even allow for me to check it. Is there a solution to why I can't check the box? Or does someone know if there is another way to do a distinct count in a pivot table? thanks for any assistance.
Bookmarks