In SSRS, trying to use Last(), to return last row from dataset

Question

I have an expression outside my table, where i'm trying to read the last record in from my dataset. Is Last() not a valid function or something? It's not erroring, just nothing is getting displayed.

=Last(Fields!IntialBalanceRolling.Value, "SupplierTransaction")

Answer 1

you can sort your data descending and use this:

=First(Fields!IntialBalanceRolling.Value, "SupplierTransaction")