I need separate formulas as the client would like the answers in stand alone text box unfortunately rather than in a table with a dimension. The table above is mock up of the data I would want to analysis.
An example of what one of the text boxes would look like is....
Previously purchased Hats only, but now buying other items
1: Customer count
2: Hat sales previous / now
3: Non Hat sales previous / now
Any help would be appreciated as it has got me stumped!
Thanks for this, it is probably going in the right direction,but doesn't quite get the answers I want. I think it needs to involve Set Analysis, but I am not sure as the same customer has to have fulfilled several criteria before being counted. For instance, "Previously purchased Hats only, but now buying other items", means the customer has to have bought Hats and nothing else in F11, and in F12 have not bought hats, but have bought other items.