I'm writing a report in Navicat that will query a online mysql database.
I currently have a report that uses the following query to give me a total testimonial count by salesperson for the year 2010 and this works good. I need to also get a monthly total for each salesperson and keep the grand total as well.
Here is the query I'm currently using and it works good to give me a grand total. I have fields other than these but I'm assuming we can do some kind of a sum on each sales persons name then total by month.
saleperson AS 'Sales Person',
count(saleperson) AS 'Testimonial Count'
WHERE recordtime >= '2010/01/01'
AND recordtime <= '2010/12/31'
Group by saleperson
Order by count(saleperson)Desc;