In my spreadsheet I have customers and sites and multiple ID numbers within each site.
In my pivot table it will tell me the total number of ID numbers but I want to the pivot to show me the count of how many are unique.
I have not figured out how to do this yet. It seems I will have to add a helper column to add to the pivot but I've not come up with the right formula yet.
Any suggestions would be appreciated.
Thank you
Last edited by kcleere; 09-26-2012 at 03:40 PM.
I have found that this formula works to count unique items and the result can be used in my pivot table. However I think the use of this (SUMPRODUCT) formula on 17,000 rows us bringing my system to it's knees. Does anyone know a better way to add a "helper" column in the data to count unique items so then I can use that data element in my pivot?
Please Login or Register to view this content.
I too am looking to do the same thing, be it through helper column or otherwise, cheers.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks