I am working on a use case where I need to display the top 5 lines of a module as individual lines, while grouping all remaining lines under an "Others" category.
The module is dimensioned by multiple composite hierarchy lists, along with Time and Version. To achieve this, I need to use the RANK function with the Ranking Group argument.
The challenge is that I need to rank the data separately for each combination of dimensions. My approach was to create a concatenated key for the Ranking Group, but I found that only child items can be concatenated—parent hierarchy items cannot.
Has anyone encountered a similar scenario? What would be the best approach to create a ranking group for each dimensional combination when parent hierarchy items cannot be concatenated?
