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 ...
Sergei, thank you. I am a newbie in pivot table. I figured out to enable Power pivot and created the new measure created; but have difficulty in locating how to insert the measure field into the pivot table. I have looked up from ms excel forum, and https://www.howtoexcel.org/summarizing-text/, but could not find the proper way to insert the newly created measure. Please advice.
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.
- 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!