I have actually found a way to achieve this. Overlaying one sheet on top of another in a Dashboard. Other methods and ideas are welcome
The overlaying sheet options is the best one.
Hiding one sheet and showing another is easier to achieve then trying to achieve changing bins.
If there is any assistance you require in setting up these cascading sheets please let me know.
Thanks Khalid. I was just wondering if there was any other way to achieve this , and I don't have to create multiple sheets. A way where I can create the bins in a calculated field, where it would dynamically compute the number of bins to be made for a field.