Sort descending for Fiscal Year

Thidalak Photipruck

How can I sort descending for Fiscal Year in parameter?

Example 

   2022

   2021

   2020

   2019

   2018

   2017

Alexander Kappes

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

Alexander Kappes

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

 

regards

 

Alexander Kappes

Thidalak Photipruck

Dear Alexander Kappes

Thank you for your reply.

 

 

Can I sort Entities asc or desc of parameter selector or pager?

 

 

 

Best Regards

 

Thidalak Photipruck

Thidalak Photipruck

Thank you for your recommendation. Alexander Kappes

 

Regrads 

Thidalak Photipruck