In my sales table, Each Sales man makes multiple entries everyday becoz they handle more than one territory. The fields are (date, Name, Territory, calls, sales)...
date name ter sales
1 x a 20
1 x b 10
1 y a 8
2 x a 12
2 y a 6
How to count the "No of days worked, Tot calls, and Sales" for a particular period for all sales guys. I'm not able to calculate the No of days worked for each sales guy, 'coz they make more than one entry every day. I'm able to use Count(DISTINCT date).
