This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
How big is your dataset? If the size permits, what you can use is use an appends fields tool to create all combinations of numbers and percentiles. Then with a filter tool, you cna check if the average sales for a given number is greater than or equal to the min value but less than or equal to the max value.
Hope that helps, let me know if that worked for you.
You can change that from the configuration window of the Append Fields tool. There you get the option to define what happens when too many records are generated, which by default is set to error if there are more than 16 records.
You can of course go around it to allow all appends.