I'm afraid that the requirements are not clear to me.
Some facts I figure out from your descriptions are,
- You've identified the non-profitable products based on the criteria.
- You want to eliminate these products from your product catalog.
- You are worried about the risk.
The unclear thing is the detailed scenario of the risk.
A simple example could be, the risk of losing customers.
- Product A is non-profitable.
- XX% of the customers purchase Product A on a weekly basis.
- YY% of the Product A customer buy nothing except Product A from your store.
- XX% * YY% of the customers might go to other store.
So the main process is,
1. Specify the scenario (s)
2. Viz the scenario
3. Get your conclusion
Thanks. Just two things.
firstly, I have a whole list of product A’s which I got through a set of filters.
Secondly, my worry is not the YY% who buy just product A but the XX% - YY% who buy other items from the store. How can I find out the average size of their shopping bag? The amount I risk loosing if I take product A off the shelf. I can’t just ask for sum spend by customer because I have previouly filtered out everything but product A. I think its not possible. But thanks for trying.
I attached a sample workbook.
After selecting a product (non-profit product), filter works so that only the orders contain this product are left.
Then calculate the average size per order or per customer / per order.
Sample.twbx 2.4 MB
You can actually ask for sum of spend across all the products even when you filtered out other products using LOD calcs.
I just used an example attached to show that, also there's a calc in there to get to your XX-YY population.
Book1.twbx 1.2 MB
Brilliant. Thank you very much. I’ll try this later.