CODEWITHSUNDEEP
excelpivotpivot-table
Bijan
Bijan

Reputation: 8670

Excel Pivot Table Count Unique Values

I have a pivot table like so

Field       Count of Field
Value1      1
Value2      4
Value3      6

The field that shows the summation of the count shows 11 which is correct but how do I just show the unique values in Field (which is 3 in this case)

Upvotes: 0

Views: 593

Answers (1)

teylyn
teylyn

Reputation: 35990

Count the values in the Excel column and subtract 1 for the Pivot header and 1 for the Grand Total (if showing).

enter image description here

Upvotes: 1

Related Questions