Is it possible to have report with static values and calculation?


I am trying to generate a sales by salesmen report (currently using EXCEL) =>

The issues I am facing within SuiteCRM:
a) Although the values are displayed, they are not summarized into single row eg ALAN $xxxxx
b) Suite does not count number of sales
c) Can’t do simple calculations eg Average sales value

Is it possible to have such reports within SuiteCRM - to put to management’s dashboard?

I have looked at ODBC drivers to get data into EXCEL ( but that would mean external instead of dashboard.

Suite Version: 7.10.10
Sugar Version 6.5.25 (Build 344)

Thanks in advance for any pointers.

How are you currently getting the data from SuiteCRM to Excel?

Have you tried the Reports module in SuiteCRM?

Using report module to get a report of sales by salesmen. Since unable to get all the required information for management, re-key the Suite report in summarised total to Excel (with formulas) to calculate average etc

Are you familiar with SQL? Would you prefer trying to get all you need directly form the database with phpMyAdmin?