Calculation needed maybe a pivot table - Thank you

E

Eduardo

Hi and thanks in advance for your help, I have some information in a table as
follow
A B C D E
Product Region Sales rep Business Market and after that a column for each
month including a Total

I have sales information, commissions, travel expenses all with the same
format
What I need to do is to get a Gross Margin total and a Grand total for the
above items as follow
1- GM Total = Sales - Product Cost
2- Then all the other expenses (Commissions, Traves) and a subtotal for this
and then a grand Total that will be 1 + 2
I thought a pivot table because I need to sort the informationby region and
then by market or by sales rep and whithin sales rep by market,
Hope the above is clear enough. I'd appreciatte any help. thank you
 
X

Xhawk57

have you tried the subtotal function? Highlight your table and then
data>subtotal
 
E

Eduardo

Hi Xhawk57,
What happens is that I need to report it as a Profit and loss statement
where for example I will have the markets in columns and in the rows the name
of each sales rep or the description
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top