How to Create Pivot Table with Unique Counts in Google Sheets

Creating a Pivot Table with unique counts in Google Sheets involves using the "COUNTUNIQUE" function to count the number of unique values in a specified data range. Here's a step-by-step guide on how to create a Pivot Table with unique counts in Google Sheets:

1. Open your Google Sheets document with the data you want to analyze.
2. Select the range of cells containing your data. You can click and drag to highlight the range, or click on a cell and press Ctrl + A (or Cmd + A on a Mac) to select the entire sheet.
3. Click on "Data" in the menu bar, then select "Pivot table" from the dropdown menu. You can choose to create the Pivot Table in a new sheet or an existing sheet.
4. In the Pivot Table editor on the right side of the screen, you'll see "Rows," "Columns," "Values," and "Filter" sections. To create your Pivot Table, you'll need to add data fields to these sections.
5. Drag and drop the field you want to use for the row labels from the list of available fields to the "Rows" section.
6. Drag and drop the field you want to use for the column labels from the list of available fields to the "Columns" section.
7. Drag and drop the field you want to count unique values for from the list of available fields to the "Values" section.
8. Click the dropdown arrow next to "Summarize by" in the "Values" section, and select "COUNTUNIQUE" from the list of available functions. This will count the unique values in the selected data field.
9. (Optional) You can also add filters to your Pivot Table by dragging and dropping fields into the "Filter" section of the Pivot Table editor.

Example:

Example: Creating a Pivot Table with Unique Counts

Let's say you have the following data in your Google Sheet:

Product | Category | Sales
--------|----------|------
A       | X        | 100
B       | X        | 200
A       | Y        | 150
C       | Y        | 300
A       | X        | 100
B       | Y        | 250
C       | X        | 350

You want to create a Pivot Table showing the unique count of products sold in each category. Here's how you would do it:

1. Select the range A1:C8.
2. Click on "Data" in the menu bar, then select "Pivot table." Choose to create the Pivot Table in a new sheet or an existing sheet.
3. In the Pivot Table editor, drag and drop "Category" to the "Rows" section and "Product" to the "Values" section.
4. Click the dropdown arrow next to "Summarize by" in the "Values" section, and select "COUNTUNIQUE" from the list of available functions.

Your Pivot Table should now show the unique counts of products sold in each category:

Category | COUNTUNIQUE of Product
---------|-----------------------
X        | 3
Y        | 3