How can I sort descending for Fiscal Year in parameter?
Dear Thidalak Photipruck,
thanks for your request.
To sort Entites Asc or Desc you can use the Sort of the layout elements (DataView, Chart, ...).
See little sample
You have to take care that the entity to sort has to be the lowest one of your row dimensions.
Hope it helps
Dear Alexander Kappes
Thank you for your reply.
Can I sort Entities asc or desc of parameter selector or pager?
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.
Thank you for your recommendation. Alexander Kappes
Retrieving data ...