| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
count distinct in Pivot table
the data is alike
A B C A when I count, I want to count how many distinct items, the result of above data shouls show only 3 (A, B and C). when I use pivot, the total shows 4 (counting 2 As). Pls help how to get this done. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
| Count in Pivot Table | Excel Worksheet Functions | |||
| Pivot Table Unique Count | Excel Worksheet Functions | |||
| Count Distinct Values by Group Using Pivot Table (NM) | Excel Worksheet Functions | |||
| How do I get a pivot table to sum instead of giving me a count? | Excel Worksheet Functions | |||
Threaded Mode
