How to sort the "Page- drop down" in the report

I am using eazybi with external source (SQL) to generate report.
Dimension - “ReportDate” is used as Page in eazyBI report. I want to get latest date as my default selection in the drop down.
How to do that?


You can create a calculated member in this dimension to access the last member using a function Tail to get a member from the bottom of a set of this dimension members:


Daina /