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

Questions & Answers
1

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?

Untitled

2

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:

Aggregate(
 Tail([ReportDate].[ReportDate].Members).Item(0)
)

Daina / support@eazybi.com