How to change data type of columns within groups

[Anonymous]

Hello,

I have created grouping based on two columns and I want to do some tranformation on the group ( like I have to split that column and then sort and then merge within the group) 

I am facing issue while sorting ( when I sort the numbers instaed of 1,2,3...10, I am getting 1,10,2,3,4) It's because of datatype as I have alphanumeric data type for this column. I changed it to integer within group but when I expand the group,datatype is again getting changed to alphanumeric.

Can someone please help on this?

Thanks,

Shweta

[Mahesh0016]

@Anonymous  I think you need to change in M code 

= Table.Group(#"Changed Type", {"Name"}, {{"By Name", each List.Sum([No]), type nullable text}})

@Anonymous I hope this helps you!THANK YOU!!