How do I make index like Excel ?

Dear Experts, I would like to create an unsorted index on an OLAP table in the Analytics new sheet.

​

I'm use pql

​

dimension

1. INDEX_ORDER (COUNT (DISTINCT "table"."column"))
2. "table"."caseid"

​

kpi

count("table"."caseid")

​

now If I sort case count, ​Indexes and case IDs are turned into a set.

​

I want the index value to not change even if I sort by case count.

​

ex)

​

index | caseid | case count

​

1 | A | 3

2 | B | 2

3 | C | 1

​sorting ->

• ​now

index | caseid | case count (sort)

​

3 | C | 1

2 | B | 2

1 | A | 3

• Goal

index | caseid | case count (sort)

​

1 | C | 1

2 | B | 2

3 | A | 3

-> This is my goal