Yes, i have to create a rank of the weighted sum of the three ranks ie., Rank(RankA*x% + RankB*y% + RankC*z%).
I made progress using the Advanced aggregation you suggested.
I was able to make some progress in displaying the top N values in one single 'text object'.
However, my requirement also needed me to display some additional dimension and expression values when I hover over each of the Dimension values in the 'text object'.
This leads me to create one 'text object' for each Rank. Then, i need to somehow use the 'Help Text' under 'Caption tab' of the 'text object' to display the required additional dimension and expression values relevant to the Dimension.
So, i gave up on this approach and started looking at creating one 'Straight Table' for each of the Dimension values that would look like a 'text object' as Marco also suggested.
I started using this approach. Since I have to display more details when I hover over each of the Dimension values, I ended up creating about 300 straight tables with Conditional show/hide of each value ie., one for each Dimension value as I need to display all the Dimension values by Default. All these 300 straight tables are arranged in the required order of Top N , Everything in Between, Bottom N.
This has affected the Dashboard performance. The dashboard is not loading data unless i pass very little data.
So, even though I have visually what the user is looking to see, it just not effectively reloading data as needed.
I appreciate any advice and thank you for the help so far