I’d like a report that clearly differentiates between sale items and full-price items, based on whether a product is actively marked as “sale” at the time of purchase - not inferred solely from margin or discount levels.

After Black Friday, I wanted to review performance and understand:

How many items sold during the period were on sale

How many were sold at full price

The revenue split between sale and non-sale items

At the moment, this is difficult to assess accurately if we rely only on the margin column, as margin alone doesn’t reliably indicate whether an item was intentionally part of a sale or promotional activity.