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

đź’¬ General Discussion
1

Hello

I am trying to generate a sales by salesmen report (currently using EXCEL) => https://prnt.sc/nr79od

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 (https://www.cdata.com/drivers/suitecrm/odbc/) 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.

2

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

Have you tried the Reports module in SuiteCRM?

3

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

4

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