Sales Report

For MoneyWorks Consultants only
Post Reply
Accounting 4 Profit Ltd
Posts: 3
Joined: 24 Aug 2006 19:43
Location: West Harbour
Contact:

Sales Report

Post by Accounting 4 Profit Ltd » 21 Oct 2008 19:31

I am trying to do a report which details Customer; Net Sales; Cost of Sales: Gross Margin $; Gross Margin %; % of Total Sales; - then sorted in descending order of sales value (i.e. most to least);


I can get everything except %of total sales and cannot get the ranking.

Can anyone help?

User avatar
rowan
Posts: 643
Joined: 23 Apr 2004 15:17
Region: New Zealand
Location: Wanaka
Contact:

Post by rowan » 23 Oct 2008 21:07

You would need to build the results into a table, using TableAccumulate. Then use TableSort.

Calculate the % of total as you are outputting the table - you'll know the total by then.

Post Reply