| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table Calculation
I currently have a Pivot Table that looks similar to the following:
User ID John 12345 12346 12347 Jane 2345 2348 Greg 3499 What I am trying to do is add a calculated field that counts the # of ID's per person, so I can track - Number of users with 1 ID - Number of users with 2 ID's etc Any help is appreciated Regards Tim |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pivot Table Calculation
In Layout: Drag ID out of ROW
DATA should say Count of ID |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table % Growth Calculation | Excel Discussion (Misc queries) | |||
| Pivot Table % calculation | Excel Discussion (Misc queries) | |||
| How to Add a Calculation to a Pivot Table ? | Excel Worksheet Functions | |||
| pivot table % calculation | Excel Worksheet Functions | |||
| Pivot Table % calculation | Excel Worksheet Functions | |||
Linear Mode
