cancel
Showing results for 
Search instead for 
Did you mean: 

On Profit and Loss statement, how can I show a column with a percentage to the sales total for all the accounts ?

Laura_Nest
Participant
0 Kudos

On the P&L statement, my client would like to see the percentage to the sales/revenue subtotal for each account and subtotal. For example, the cost of goods sold account needs to print a percentage compared to the revenue total $ (which is 100%). So if the total sales/revenue is $200,000 and the cost of goods account is $95,000, I want a column to print 47.5% next to the cost of goods sold account. My client wants to see what each account is as a percentage compared total sales/revenue on the profit and loss statement.

I haven't been able to find this on a standard report.  Am I missing it or is this only possible after exporting to Excel?

Thanks,

Laura

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

This message was moderated.

KennedyT21
Active Contributor
0 Kudos

Hi Laura Nesteriak....

In standard report this is not possible... You can develop on your  own using Crystal Report

Regards

Kennedy

Former Member
0 Kudos

Hi Laura,

You may create a Crystal Report for this purpose.

Thanks,

Gordon

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi Laura Nesteriak,

I think not possibe in standard report and better to export it to excel.

Thanks & Regards,

Nagarajan