Skip to main content
L
LKabbaj
Newcomer
November 22, 2021

Cube View Sorting

  • November 22, 2021
  • 1 reply
  • 0 views

Source:   Migrated from Champions

Hi All,
This is my first time posting and happy to do that!
I’ve built a cubeview showing the clients in rows and Revenues in columns but struggling to sort my client based on the revenues (descendant).
Is there any effective way to apply descendant / ascendant sorting ?
Thanks

1 reply

MikeG
MikeG
Contributor
November 22, 2021

Hi Lotfi, you need a Finance BR for the ranking logic. There is an example in GolfStream.

MikeG_0-1637616271504.png

 

image.png710×421 38.3 KB

 

Take a look at the Row definitions and you can see the syntax on how to call the Business rule and also the Finance BR name that has the sort/rank logic and example.

R
rhankey
Newcomer
November 22, 2021

Take a look at OS’s Finance/XFR_MemberListRanked business rule that I believe is included in GolfStream, which returns ranked/sorted lists of members. You may need to modify it a little to do precisely what you need, but it has working code elements for what you are asking.

L
LKabbajAuthor
Newcomer
November 22, 2021

Much Appreciated dear Robin, that’s great !
Thanks for your clarifications !

Terms & ConditionsAccessibility statement