Nov-02-2022, 07:17 PM
I believe this is how things should be broken out for sheet 1.
Output:Segment|Country|Product|Discount Band|Units Sold|Manufacturing Price|Sale Price|Gross Sales|Discounts|Sales|COGS|Profit|Date|Month Number|Month Name|Year
Government|Canada|Carretera|None|1618.5|$3.00|$20.00|$32,370.00|$-|$32,370.00|$16,185.00|$16,185.00|01/01/2014|1|January|2014
Channel Partners|Canada|Montana|None|2518|$5.00|$12.00|$30,216.00|$-|$30,216.00|$7,554.00|$22,662.00|01/06/2014|6|June|2014
Some of the dollar columns are a big sketchy, but I'm not an accountant.