i want to compare the amount of sales between one set (composed by only invoice that contain at the same time the list of products selected in group1) and another (composed by only invoice that contain at the same time the list of products selected in group2). See attachment.
NO_Invoice, Product, Retail, Sales, Qty
1, a, aa, 10, 1
1, b, aa, 20, 1
1, c, aa, 30, 1
2, a, aa, 10, 1
2, b, aa, 20, 1
3, e, bb, 40, 1
3, f, bb, 50, 1
3, b, bb, 20, 1
3, c, bb, 60, 2
For example i want create a chart with dimension Reatil and measure sum(sales)
if i select in group1: A and B and in group2 B and E
I want toaddonly products (that are present in group1) that appearon the same invoice. This meansthat the retailbbhas never issueda bill thatcontains boththe product a and productb. It should be bb=0 for group1 because in invoice 3 don't appear a sell of product a (group1 is composed: a AND b). I hope I made myself clear.