Sort Row Orders in Template with Start Expression.
I m trying to sort the row orders in Template.
<<Start:SELECT(Fixtures For Report[_RowNumber],[Fixture Date]>(Today()-7))>>
This is Expression to pull the data from the tables contains the records to show in template and it is working fine.
On “Fixtures For Report” table, we have column with name [Load ID]. What I m trying to do is to sort this table by two columns. First priority is given to Load ID column and secondary sort is [Fixture Date]
How can we alter the expression to use select and orderby all together at the same time?