GROSS PROFIT

[#1]

I have more than 100,000 lines showing invoice data. Few lines are shown below.

Invoice NO	Purchase Amount	Sold Amount
INV001	100	125
INV002	125	130
INV003	140	148
INV004	150	165
INV005	200	250

I want table as below

Invoice NO	Purchase Amount	Sold Amount	% Profit
INV001	100	125	20.00%
INV002	125	130	3.85%
INV003	140	148	5.41%
INV004	150	165	9.09%
INV005	200	250	20.00%
TOTAL	715	818	12.59%

Kindly help me.

[#2]

Use this:

([Sold amount]-[Purchase Amount])/[Sold Amount]

Go to Number Tab:

Select Fixed to: 2 Dec

Tick on checkbox "Show in %age"

[#3]

This is already done and I am getting TOTAL for "Purchase Amount" and "SOLD AMOUNT" but not getting total for % PROFIT.

[#4]

Hi,

I think Erika giving the correct answer, if not that is exactly, what you want?

A little more information would be good.

Regards

Gabriel

[#5]

I want total at bottom for Purchase Amount, Sold Amount & % Profit.....

[#6]

If you are using a pivot table, you need to go to presentation tab and click show partial summaries for the top dimension, or change the table to a straight table

[#7]

Use:

if u r using Pivot table:

Sum(

([Sold amount]-[Purchase Amount])/[Sold Amount]

)

[#8]

Thanks for your response. Sorry but I am not getting TOTAL by using PIVOT TABLE for % Profit

[its_anandrjs]

Hi,

See the attached sample for clearity

And suntotal of Purchase Amount, Sold Amount & % Profit.....

By the help of straight table you get this in pivot it is not possible for the expression, there you do only on dimensions.

Regards

Anand

[#10]

Can u upload ur Sample App.