Report Column of a Number Drop Down from a custom form

[MattEl5]

Hi Folks, 

Here's what i have - Project details form with a custom field with numbers 1-10 in a drop down.
Name - ED Client Review Rounds,  Format - Number, Display - Single select dropdown.
When someone selects a number, I want that to reflect in a report column, and then a chart. 

So on the report i want it to group all the projects with 1 selected, all with 2 selected, etc etc. 
and then put that into a pie chart or a bar chart or whatever. 

Any help would be greatly appreciated! for sorting out a column thing and tips on generating a report! thanks! 

[MattEl5]

[Srinija_N · Accepted solution]

Hello MattEl5,

you can add single-select dropdown field as the columns, grouping or chart like you would do with any other field and it should work fine. Adding sample screenshots how i did it. Hope this helps.

[MattEl5]

Thank you! I think it was because i was trying to group by something else first! but the pictures really helped me follow it through. thanks again!