I have one invoice, which records details of three different products. The invoice number is the unique identifier, which means 1 invoice=1 sale (irrespective of the number of products included).
I wanted to record this on Excel on three different rows, but then they would be shown as three different sales, not one.
At the end of the week, I need to find out how many sales I have made, and also how many items of each product has been sold.
I need advice on how I can achieve both my objectives.