i have got thousands of time entries against couple of hundered people on different dates, trying to calculate how many people were present on a particular day. when i make pivot and ..it counts number of entries not names..e.g. if somebody worked 8hrs straight time and 2 hrs overtime..it is counting both separtely...hence counting people twice..any help would be highly appreciated and you'll make my life better..
regards,
regards,