The different sales range can be created using interval match function.
PFA the QS file. Reload it and check to get the same output as expected.
Hope this solve your problem.
Yeah i do save the file..
The modification is done in the script.
Pls do reload the file from your machine and create a straight table having
dimension = range
measure = count(distinct Sku)
Attaching the file again FYR.
thanks for the info and yes the script is correct.
But when I am trying to connect to my data it doesn't work. I dont know why ?
Data grouping was not right. I have only 2 group.
I've already set the script like yours
LOAD * INLINE [
Start, End, Sales_Range
0,0 , No_Sales
1, 5000000, 1-5mio
5000001, 10000000, 5-10mio
10000001, 20000000, 10-20mio
20000001, 40000000, 20-40mio
40000001, 40000001++, >40
do you know why ?