Hi whoiswct
What version of Excel are you using! If it is 2013, have a look here
Just be aware that you will then have an OLAP pivot table which has a few drawbacks (such as no native date grouping)
This website wants to know your momentum - | Deny | | Allow |
Excel 2010 with free PowerPivot Add-In
Count unique values.
Examples with regular PivotTable and
PowerPivot DAX DistinctCount()
http://58918aa17d4002474361-7ac2b7ee...04_17_13a.xlsx
If you get *.zip, don't unzip, just rename *.xlsx
Bookmarks