11-22-2021 04:23 PM - last edited on 05-24-2023 11:52 AM by JackLacava
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
11-22-2021 04:25 PM
Hi Lotfi, you need a Finance BR for the ranking logic. There is an example in GolfStream.
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.
11-22-2021 04:25 PM
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.
11-22-2021 04:26 PM
Much Appreciated dear Robin, that’s great !
Thanks for your clarifications !
11-22-2021 04:26 PM
Much Appreciated dear Michael, that’s great ! Would love to have this feature as “standard” meaning with no Business rule in future releases, do you know if OS have Something planned in the pipe ? in other CPM platform, it’s just a click, like Excel…
Thanks for your clarifications !