Thank you very much for looking into this. This answers the question i had asked. I should have been little more clear with what i exactly wanted. So, i would also like to show the same viz. when using other filters (>5000, 1000 - 5000) as well.
For example when i switch the filter to 1000 - 5000 it should show only accessories, bookcases, Furnishing, Machines, Paper and supplies.
That works. Thank you very much.
You are welcome.
Thanks again for your solution.I have a follow up question. I converted the continuous filter to discrete using the below formula. It created an attribute, which i could still use as a discrete filter. The problem is i cannot sort the order of the values within the filter. Would you be able to help me with it.
I basically want the order of the filter to be <1000, 1000 - 5000 and >5000.
i have attached the workbook if it helps.
That's a great hack. Thank again for all your help.