Sugar Reports does not allow reports to be generated like excel, any suggestions?

Aloha Sugar Club, I do user metrics each month and one of the reports I do manually after getting raw data from Sugar and massaging it in excel is how many calls the salespeople (80) do each month. 

In excel I have the rows as the Salesperson names and then the columns as the month of the created call. Within each cell the amount of calls for that user for that month. Very simple report, but out of box Sugar cannot render this type of report I was told from support. 

Any ideas or solutions out there?

Thank you 

Parents Reply Children
  • Awesome, appreciate it, Chris! This worked great, other than using the username which we have designated as their email addresses. This report intended audience is management. I would have preferred if the define by group had an option for full name. I see that there are options for first and last name as separately but no full name. I have users where some have the same first name and others have the same last names, so this report doesnt work good for those options, just the username option. Managers might not know email addresses, especially new ones. Any other ideas?