
1. Re: How to show a list of numbers of POS which sold 50,49,48,...,1,0 products
Steve Taylor May 27, 2016 6:37 AM (in response to Liliya Grinko)Hello Liliya,
Do you have an anonymised dataset you can share? It'd make it much easier to assist you.
Many thanks
Steve

2. Re: How to show a list of numbers of POS which sold 50,49,48,...,1,0 products
Liliya Grinko May 30, 2016 6:17 AM (in response to Steve Taylor)Hello Steve,
Sure. Please find an Excel document attached. In order not to overload you with the data, I chose 1 distributor. POSID  ID of its points of sales, ProductID  ID of 50 products that a point must sell, SellOut=Sales.
Thank you!

Dataset.xlsx 149.4 KB


3. Re: How to show a list of numbers of POS which sold 50,49,48,...,1,0 products
Steve Taylor May 31, 2016 12:54 AM (in response to Liliya Grinko)Hello Liliya
Sorry for the delay, it was bank holiday here yesterday so no work for us!
I think I have a solution. Rather than define 150 in a fixed parameter/list I used this calculation and made it a dimension:
{FIXED [Posid]: COUNTD([Product ID])}
This, for any given distributor, provides the number of POS with N products, it's called "Count Products" in the attached workbook.
Then, I used COUNTD([Posid]) for the "actual number of POS with N products" (called "Count POS with N Products" in the workbook) and put those two columns together in a table in the workbook.
I added your parameter based calculation for comparison (called Liliya actual number POS calc).
I hope this works when you apply it to your whole dataset, please get in touch if it doesn't.
Thanks
Steve

Liliya example.twbx 32.8 KB


4. Re: How to show a list of numbers of POS which sold 50,49,48,...,1,0 products
Liliya Grinko May 31, 2016 3:46 AM (in response to Steve Taylor)Thank you very much, Steve!
I adapted calculations a bit for my case (added Period to LOD and counted only POS which had sales>0) and it works! Very smart solution!

5. Re: How to show a list of numbers of POS which sold 50,49,48,...,1,0 products
Steve Taylor May 31, 2016 3:49 AM (in response to Liliya Grinko)You're welcome!
Glad it worked out.