Dynamic Bucketing of values using Formulas

[Ramu H S]

Hi All,

I have a dataset which needs to be bucketed dynamically to be used in a Slicer.

Details of the problem.

I have Sales Data with values ranging from 1k to 10M+, I want to provide a slicer to the sales folks to be able to filter all deals which are greater than 10K or all Deals which are greater than 100K or All Deals which are greater than 1M.

I don't want bucket it as 0-10K, 10-100K, 100-500K, 500k-1M, 1M-10M, 10+ etc

Let me know if there is any formula which can dynamically select all data greater than a specific value?

Regards,
Ramu

 

[Hui]

Ramu

Firstly, Welcome to the Chandoo.org Forums

Typically you take the Maximum value minus the Minimum value and divide the difference by the number of buckets you want. Then add that answer to the minimum repeatedly to get each bucket

If you are using uneven ranges you could attempt either using a Lookup Table of manually defined ranges or a Log Function to derive the ranges

I'd suggest posting a sample file with examples and example answers as you expect them

 

[Ramu H S]

Thank you for the Response Hui, uploaded the sample file.