![]() |
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? |
All times are GMT +1. The time now is 03:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com