Dynamically changing first row in straight table

[chhavi376]

Hi all,

I have a straight table and a filter(alternate state for which is different from the straight table).

I want the straight table to display the row corresponding to the value selected in the filter at the top, following the other rows.

Please find the attached sample for more clarity.

[sunny_talwar]

Try this sort expression:

=RangeSum(Only({Alt1} Number)*100000000, Number)