| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Count Distinct Values by Group Using Pivot Table (NM)
|
|
#2
|
|||
|
|||
|
|
|
#3
|
|||
|
|||
|
|
|
#4
|
|||
|
|||
|
To get specific help, you'd need to provide some details about what
you're trying to do, and the layout of your pivot table. A pivot table won't calculate a unique count. However, you could add a column to the database, then add that field to the pivot table. For example, if you want to count the customers in column A, use the following formula in row 2: =IF(COUNTIF(A$2:A2,A2)=1,1,0) Copy this formula down to all rows in the database. Add this field to the pivot table data area, as a Sum, and you'll get a count of unique items, or a count of records. You could multiply this field in your formula. MCP wrote: -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| 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 | |||
| Can't group pivot table items by month in Excel | Excel Discussion (Misc queries) | |||
| Sum minimum values in a pivot table | Excel Worksheet Functions | |||
| Pivot Table - Group by Month - Show Items with no data | Excel Discussion (Misc queries) | |||
| How do I get a pivot table to sum instead of giving me a count? | Excel Worksheet Functions | |||
Linear Mode
