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 for each row?

 

Cheers

1 Reply

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft 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