Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting in Pivot table
The Group A of the 2 applicants have 3 applications each
i can only show how many applications in total - 6 How can i count how many applicants in Group A? My Pivot table is Group, Applicant, Application Then the table can show Group A (2) Application (6) Thanks a lot. Tony |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting in Pivot table
A pivot table won't calculate a unique count. However, you could add a
column to the source table, then add that field to the pivottable. For example, to count unique applicants per group, where Group name is in column C, and applicant name is in column D: =IF(SUMPRODUCT(($C$2:$C2=C2)*($D$2:$D2=D2))1,0,1) Copy this formula down to all rows in the database. In the pivot table, add Group name to the row area, and add this field to the data area, and you'll get a count of unique applicants. Tony wrote: The Group A of the 2 applicants have 3 applications each i can only show how many applications in total - 6 How can i count how many applicants in Group A? My Pivot table is Group, Applicant, Application Then the table can show Group A (2) Application (6) Thanks a lot. Tony -- 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 | |||
Pivot Table not counting | Excel Discussion (Misc queries) | |||
Pivot Table Counting | Excel Worksheet Functions | |||
Pivot table and counting. | Excel Discussion (Misc queries) | |||
Counting .5 in a pivot table | Excel Worksheet Functions | |||
Pivot table and counting | Excel Worksheet Functions |