How to create dimension to show the range

[#1]

Hello Everyone,

I have below scenario:

I have attendee count and expenses, both are measures.

I need to create a chart having range as a dimension, means from 0-10 attendees what is the sum(expenses), for 10-20 what is the sum like that till 90-100.

in x axis i need to show 0-10 to 90-100 values, this one i need to calculate from count

any suggestions please

Thanks in advance

Regards,

Sreeharsha V

[#2]

Thanks for the immediate response and it is so helpful