Top Tip on 24th October 2013
#XL2013tip
Unique Count available 4 Pivots.
Insert, Pivot table, tick “Add this data to the Data Model”, OK
Summarise values=distinct count
1 January
#XL2013tip
Unique Count available 4 Pivots.
Insert, Pivot table, tick “Add this data to the Data Model”, OK
Summarise values=distinct count