If I understand you correctly then one way you can get this is by using a caculated dimension
=IF (CoilWeight < 51 , '0 - 50' ,
IF (CoilWeight >= 51 and CoilWeight <= 100, '51-100',
IF (CoilWeight >= 101 and CoilWeight <= 150, '101-150',
IF (CoilWeight >= 151 and CoilWeight <= 200, '51-200',
This calculated dimesion groups your Dimension.
Let me know if you get this to work, and if this is what you are looking for.