Forum Discussion
How to use Manual Numeric ranges? Groups/Bins
Hello all
I have Store Id's, month and sales$ for 2019. This is my raw data.
TABLE1
I want the result like below.
I got the answer for Store count. I want
1.The sum of the sales of the all doors which fall under that range, and
2.the average sales of each door in that range.
| Sales range | Store count whose sum(sales) is between this range | Sum of sales between that range | Average of each door in this range |
| 0-30 | 1 | 27 | |
| 30-100 | 1 | 80 | |
| 100-200 | 4 | … | |
| 200-400 | 1 | …. | |
| >400 | 1 |
How do I do this. Please help.
Hello Anonymous
The folks from SQLBI have done a good article on this process. You can find it here: https://www.daxpatterns.com/dynamic-segmentation/
1 Reply
- jdbuchanan71
Super User
Hello Anonymous
The folks from SQLBI have done a good article on this process. You can find it here: https://www.daxpatterns.com/dynamic-segmentation/