Creat a new report

Hi,

I have a requirement were in i need to get all the employees personel number based on the sales office and calculate the gmd , revenue and profits.Sales employees are divided on the base of software or hardware or services with there corresponding sales group.Firstly i need to calculate all the gmd , revenue and profits made by all the employee falling under the category of one sales office.Like wise i've different sales office.After calcultaing all the employee gmd,revenue and profits made corresponding to software or hardware of services i need to popultate the fields and calculate the total for the repective fields(for hardware and software we calculate the commissions based on GMD and for services purely based on revenue).

Any body who have worked on this kind of scenario(for branch revenue,profit and commissions) please help me.....

Note:For this we have our own customising tables and we use very few standard tables(like pa001 or pa002 HR PA tables)