can you please share the sample data or is it possible to share the workbook?? sales values can be dynamic. is there any reason you have hard coded the same in the calculated field?
I Haven't hard-corded those values . I am showing here count of customers in that sales range . Though sales is dynamic instead of sum i will consider avg. ( Imagine, As of now my sales value will be in that range ). If customer1 is having sales figure 199555 then he shud be in one range and if cusotmer 2 is having sales with 398787 then he shud belongs to one range as per my calclulation.