I would like to create a report to show individual product sales by pricing level and rate. However since pricing and price levels may have changed over time, we also need the average price level rate.
So something like this :
SKU | Total Sales | Base Price | Price Level 1 | Average Rate | Price Level 2 | Average Rate
ENG1 | 100 | $299 | 75 | $150 | 25 | $130