Sorting Data when you've duplicate regions in another column

[utkarshsingh3]

Hello! I have 3 columns in a table. First column is Order, Second is Regions and Third is Regions groups (I have grouped US East, West, Central and National as US All Entities). Now, when I try to sort the data by First Column "Order". It's not letting me to sort the data. I want to sort the data by Order.

.Table - I want to sort the data by OrderError

[mh2587 · Accepted solution]

You can't sort that as there multiple orders values for US All Entities for that create another column for each reporting region group assign unique number in that column

[mh2587 · Accepted solution]

You can't sort that as there multiple orders values for US All Entities for that create another column for each reporting region group assign unique number in that column

[utkarshsingh3]

its not happening...I tried giving order for reporting groups. Can you please advise?

[v-xinruzhu-msft · Accepted solution]

Hi, 

Thanks for the solution @mh2587  provided, and i want to offer some more informaiton for user to refer to.

hello @utkarshsingh3 , based on your description, you can create a new table.

Table 2 = SUMMARIZE('Table',[Reporting Region(groups)],"Order",MIN('Table'[Order]))

Then click the group column and select sort by order in the new table, and create a relationship between tables.

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.