Analyzing Company Profits by Category - Need to develop a template

[genoforce]

I have this problem that im spending my second night on and its supposed to be easy. i need to develop a template to solve next years marketing, but i dont even know how to start this. If any of you have a minute or two and can help me, let me know..


Problem attached

[Kieran]

Genoforce,

I suggest that you look at the functionality provided in Excel with pivot tables.
There is plenty in the online help, or try sites like this