Sort descending for Fiscal Year

Dear Thidalak Photipruck,

not really. A pager or selector reduces the slices of the database to analyse.

For sure, when you reduce the dimension used for the filter the layout element shows only the elements left.

To change the sorting asc or desc depending your choice you can do the following.

You build up a little cube for sorting.

Additionaly you insert an entity with 2 Elements (Ascending and descending)

The cube consists these entity plus the entity you want to sort ascending or descending.

The cube is filled manually and has to be changed, when you insert new members to timeline.

Hope it helps

regards

Alexander Kappes