I have a report that needs to shows Company number, Customer name, revenues, costs, margin$ and margin% for a specific month range (as input by the user as a parameter).
The data has Company Number, Customer name, revenues, costs, month.
The report is grouped by Company, then by Customer name. I have the totals summarized in the Customer name group footer to get me total revenues, total costs (grouped by the Month range).
How do I get a margin$ and margin% because they would be calculated based on the totals (total revenues, total costs) for each Customer?
I supress the detail and only show the group summary and the report would look like this (remember, I am able to calc the Revenues and Costs but not the Revenue$ and Revenue%):
Customer Name Revenues Costs Revenue$ Revenue%
Exxon 123,252 58,989 64,263 52.06%
BP 500,000 100,000 400,000 80.00%
Thanks!
IP Logged
