How to create case-when dimension for a measure?

[Sowndarya]

I have a wild scenario where I need to create dimension with case-when but the field that I am comparing inside is a measure, example I need to create a dimension for the user-group in an account, like if the total users is 0-50 then "0-50 users" and so on.. but the total users is a measure in my view, how to handle this, I especially needed it to be a dimension as I need to pivot it in my visualization, i.e based on the user group I need to show a revenue. kindly help

[GavinW]

You would need to do this in a derived table, I think. You would need to turn that measure into a dimension by aggregating it and creating a new table where it is actually a dimension.

Here it is in the documentation, or you might find this a more human coverage of the same topic.