Forum Discussion
Mchen95
Jun 17, 2021Copper Contributor
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 ...
StoneKiwi
Jun 17, 2021Iron Contributor
Hi,
Try adding another column that makes GL109 and GL109-title the same.
e.g. =LEFT(cellwithGL109-title, 5)
=GL109
Try adding another column that makes GL109 and GL109-title the same.
e.g. =LEFT(cellwithGL109-title, 5)
=GL109