Forum Discussion
add data to model option for building unique count pivots ...
Hi
hi!
I am using excel version 16.44 on a MAC.
I am trying to build a pivot table that will return unique counts. The add to data model option is not available in my version.
I am dealing with a large amount of data that has duplicates and I want to pivot and sum the unique count of values.
Any thoughts on why from the group?
Thank you!
Courtney
7 Replies
cujstoner Not sure what you want to count. Currently your pivot table counts "Tag 1", not "Review ID" which is in column A.
With regard to Data Model, that's NOT supported by any Excel version for the Mac, unfortunately. Windows only!
Yes. At the review ID level, display in a row the list of tags and then count 1 (unique or distinct) occurrence.
In the raw data the review ID is ascribed to a unique set of information. There are several rows with the same review ID and various tags that are repeated in each row.
I had hopes of creating a pivot and do unique count on the values so I could arrive at a view of review ID, list of tags per review ID and if there was one occurrence.
Since Mac does not have this feature I was also considering building a master data table off of the raw data with a series of lookups. But I'd have to lookup along columns and rows.
any thoughts?
cujstoner I'm sure you have a clear picture in your head with regard to the end result. Though, I'm not seeing it (yet). Perhaps you can describe the logic you wish to apply. For instance, the first 6 items in the raw data (rows 2:7) share the same Review ID. Five possible reviewers, one Sentiment per item and five possible tags. What would you want to count for this one Review ID?
