How do I count unique values in a pivot table?

Answer 1

One of the options along with sum and count, is count unique. The only catch, is that you when you create the pivot table, you must click the checkbox for "Add this data to the Data Model". Otherwise you don't get this option.