hi Folks
Still stuck on this one. I've posted a file with what I have and with what I want. I'm currently using Powerpivot so want to do it that way...Have a chart of accounts and set of balances for 3 groups - PTD/YTD for each item.
I want to generate a gross profit figure that will appear under Revenue and COGS rather than in another column. Any suggestions on how to get what I want
<colgroup><col><col span="2"><col><col><col><col span="3"></colgroup><tbody>
</tbody>
Still stuck on this one. I've posted a file with what I have and with what I want. I'm currently using Powerpivot so want to do it that way...Have a chart of accounts and set of balances for 3 groups - PTD/YTD for each item.
I want to generate a gross profit figure that will appear under Revenue and COGS rather than in another column. Any suggestions on how to get what I want
What I've got | What I want | |||||||
Revenue | PTD | YTD | Gross Profit PTd | Revenue | PTD | YTD | ||
Widgets | 450 | 1000 | 849 | Widgets | 450 | 1000 | ||
Gadgets | 500 | 1500 | Gadgets | 500 | 1500 | |||
Total | 950 | 2500 | Total | 950 | 2500 | |||
COGS | ||||||||
Steel | 56 | 127 | COGS | |||||
Nuts | 45 | 100 | Steel | 56 | 127 | |||
Total COGS | 101 | 227 | Nuts | 45 | 100 | |||
Costs | Total COGS | 101 | 227 | |||||
Wages | 100 | 500 | Gross Profit | 849 | 2273 | |||
Electricity | 50 | 230 | Costs | |||||
Office | 34 | 100 | Wages | 100 | 500 | |||
Total Costs | 184 | 830 | Electricity | 50 | 230 | |||
Office | 34 | 100 | ||||||
Total Costs | 184 | 830 | ||||||
Net Profit | 665 | 1443 |
<colgroup><col><col span="2"><col><col><col><col span="3"></colgroup><tbody>
</tbody>