| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting entries in a pivot table
I have a Pivot Table based on data provided by a rep. The data shows a
business visited, the department visited the date and what was discussed. I need to count the number of times the business has been visited. Unfortunatly because one visit to the business might generate 4 or 5 departments visited I am getting incorrect answers. If he visited a business twice one visiting 2 departments and the second time 3 then the total I get is 5 and not 2. How can I count the number of times he visited the company? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table and counting totals | Excel Worksheet Functions | |||
| OLAP Pivot table - How to show items with no data ? | Excel Worksheet Functions | |||
| counting in pivot table | Excel Worksheet Functions | |||
| Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
| Counting blank cells in Pivot Table | Excel Worksheet Functions | |||
Threaded Mode
