Subscribe now and choose from over 30 free gifts worth up to £49 - Plus get £25 to spend in our shop
A bit like this...
I have items named 'Bike A' and 'Bike B' stored in 15 unique storage locations.
Sum of 'Bike A' is 15, stored in 10 unique storage locations, Sum of 'Bike B' is 16 stored in 11 unique storage locations.
So, on my pivot, how do I get it to count that there are only 2 x unique descriptions, being 'Bike A' and 'Bike B'?
I obviously have a much larger data set, but hopefully you get my drift....
Thanks.
Not sure I understand this . IF you put Bike A into the pivot on the Y axis you will see it only once. Failing that would "count unique" help ?
Version 2013 has count distinct using powerpivot
http://www.contextures.com/pivottablecountunique.html
Sounds like you need to upgrade to a database, or google group and count in excel.
As above, not sure I understand the question... But - without using a Pivot Table (do you have to?) you can do this with a filter. This link explains it - basically, use a filter, then go to Data tab and use the Advanced Filters option.
If that doesn't answer the question, perhaps you could post a (simplified) sample table?
When you create the pivot table click the 'add to Data Model' box at the bottom of the dialogue, you'll then get a 'distinct count' option alongside the usual sum, count etc. in the pivot options