Forum Discussion
Custom column Index or Ranking by other column
Hi Team!!! I have a table with AccountReceived informations and Clients. I need to create a new custom column (like an Index) that define an order according the client column changed. I mean...
I would create another table with just the customers and put an index column on it. Then you should be able to relate the two tables and use the "Sort by" functionality or just filter your visual/page/report to that ID field <= 20.
In Query Editor, go to Add Column and then use the Add Index Column drop down in the General area of the ribbon (1st box).
I used the same select, because we've half milion records in our client table.