Forum Discussion

wxqqaz's avatar
wxqqaz
New Member
9 years ago

Index column for summarised table

Hi guys   Does anyone know how to add an index column for a summarised table which is not directly derived from a query, or alternatively, can I just simply create a column counting the row number ...
v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi wxqqaz,

We can not add index column in the summaried table. You can add a calculated column by ranking any column in your summaried table. More details, please review RANKX function.

Best Regards,
Angelia