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

have you tried the subtotal function? Highlight your table and then
datasubtotal

"Eduardo" wrote:

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

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

"Xhawk57" wrote:

have you tried the subtotal function? Highlight your table and then
datasubtotal

"Eduardo" wrote:

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