The specific steps are as follows: Step 1: First, open WPS, select the data to be counted, and find the data-pivot table； in the toolbar; Step 2: Select the area we have selected before, or click the check box arrow on the right to make a selection. In addition, for convenience, a new table is used; Step 3: Click any cell in the newly-appeared pivot table area, and drag the Product Category field into the Row Label and Value boxes respectively; Step 4: The row labels in the PivotTable report display the count of non-repeating categories in the target C column.