In the attached, how would I add a count in the pivot of the unique values in column A from the data sheet.
In the attached, how would I add a count in the pivot of the unique values in column A from the data sheet.
=COUNT(A:A) on the pivot sheet?
Martin
Your profile says you're on Office 365, so you may already have the Dynamic Array functions, currently rolled out to users on the Monthly channel. With Dynamic Array functions, you can use the Unique() function to get a count of unique values, for e.g.
=COUNTA(UNIQUE(Data!A2:A25))
Or, if you add the source data of the pivot table to the Excel Data Model and build the pivot table from that, you can use the Distinct Count in the Value Field settings.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks