My question is around filtering on multiple items sold together. Here's our scenario:
If a shoe store wants to find out how many Shoe spray kits were sold with 'Trainer A, B. C or D' over a period, how do we only pull back sales figures for ONLY 'shoe spray kits' sold WITH any of trainer A, B, C or D? At the moment we seem to be pulling the sales data for ALL shoe spray kits sold & all trainers sold through the period, without it bringing back data for shoe spray kits sold WITH any of the trainers. So it's not combining the two together, it's bringing back all the data separate.
Thanks.
