Grouped Stock Ranking problem

[Anonymous]

I am trying to sort grouped tables in power query, as part of an assignment from datacamp. First there were instructions to right click on grouped column, then click on add custom column. But there is only custom column from examples option only. Secondly when I try to make index column, using table.addindexcolumn for a grouped column that I sorted using table.sort then it gives me error in entire column. The formula I used for table.sort is:
Table.Sort([Grouped],{{"StockPlusOrderValue", Order.Descending}})

I used for table.addindex:

Table.AddIndexColumn([SortedGroup], "CategoryGroupedRank", 1, 1)

But now it is giving me entire column error

Please help if someone knows a solution

[v-jingzhang]

Hi @Anonymous 

Can you please provide some sample data to help clarify what you have currently and what you want to achieve?

The formula looks correct. What is the error message after you used Table.AddIndexColumn([SortedGroup], "CategoryGroupedRank", 1, 1)? You can click the "Error" in a cell to see the detailed error message. 

Best Regards,
Community Support Team _ Jing

[Anonymous]

Sure, here I will share screenshots. It is northwind products data, hope this helps. I couldn't find an option to share files.it says SortedGroup not found

[v-jingzhang · Accepted solution]

Hi @Anonymous 

It should be [Sorted Group]. You are missing the space character between two words.

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.