Forum Discussion
Pivot Table Count Unique or Similar Values
Hi, I was wondering if there’s a way to create a pivot table that counts unique values. I have tried adding to data model and selecting distinct count. This works, but then I run into a problem where ...
SergeiBaklan that's what I thought. Since it did not show up in the pivot table, I suspect I created it under a wrong table. I'll see if I can figure out how to recreate under the right pivot table.
You shall have some name which is source for PivotTable. It could be Table or Range, doesn't matter.
- Yes, I tried that after reading thru online article.. Unfortunately, the Table name does not show up in "Choose fields to add to report" dialog window. Sigh!