kelvinlow39
New Member
- Joined
- May 22, 2016
- Messages
- 3
Hello,
I am looking at creating a Price Model, and I am looking at the best way to solve the problem other than having lots of columns.
My data Set looks like This
<tbody>
</tbody>
And I am looking to Extract 2 Tables that look like this
<tbody>
</tbody>
<tbody>
</tbody>
have got this to work but is does use lots of columns I was hoping for a simple way to extract the above reports
Regards
Kelvin
I am looking at creating a Price Model, and I am looking at the best way to solve the problem other than having lots of columns.
My data Set looks like This
Cost Type | Qty | Unit Mth Cost | Margin | Unit Sell | Start Date | End Date | Total Mths | Total Cost | Total Sell |
A | 10 | $80 | 30% | $114 | 1/01/2016 | 31/12/2025 | 120 | $96,000 | $137,143 |
B | 12 | $100 | 30% | $143 | 1/07/2016 | 30/06/2024 | 96 | $115,200 | $164,571 |
A | 14 | $200 | 30% | $286 | 1/07/2019 | 31/12/2022 | 42 | $117,600 | $168,000 |
B | 16 | $1,000 | 30% | $1,429 | 1/01/2018 | 31/01/2023 | 61 | $976,000 | $1,394,286 |
<tbody>
</tbody>
And I am looking to Extract 2 Tables that look like this
Fiscal or calendar year | ||||||||||
Cost | Yr1 | Yr2 | Yr3 | Yr4 | Yr5 | Yr6 | Yr7 | Yr8 | Yr9 | Yr10 |
A | $xxxx | $xxxx | $xxxx | $xxxx | $xxxx | $xxxx | $xxxx | $xxxx | $xxxx | $xxxx |
B | $xxxx | $xxxx | $xxxx | $xxxx | $xxxx | $xxxx | $xxxx | $xxxx | $xxxx | $xxxx |
<tbody>
</tbody>
Fiscal or calendar year | ||||||||||
Price | Yr1 | Yr2 | Yr3 | Yr4 | Yr5 | Yr6 | Yr7 | Yr8 | Yr9 | Yr10 |
A | $xxxx | $xxxx | $xxxx | $xxxx | $xxxx | $xxxx | $xxxx | $xxxx | $xxxx | $xxxx |
B | $xxxx | $xxxx | $xxxx | $xxxx | $xxxx | $xxxx | $xxxx | $xxxx | $xxxx | $xxxx |
<tbody>
</tbody>
have got this to work but is does use lots of columns I was hoping for a simple way to extract the above reports
Regards
Kelvin