Sorting in Table ( Top three based on a Measure and group by Dimension)

[shraddha6369]

Hello Friends,

I have a requirement where i need to show data in a sorted order in a Straight table.

Data:

load * inline [

Client, Product, Total

G, A, 1000

G, B, 2000

DB, A, 500

DWES, x, 1500

MS, y, 200

AGG, z, 1000

DB, B, 2000

];

Required output in a Table:(top 3 clients  , sorted on total by group by client)

Client  Product   Total

G              B               2000

G               A               1000

DB            B                2000

DB            A               500

DWS        X              1500

This has to be done in front end. I am trying combinations of aggr and rank but could not get  the required output. Any help will be much appreciated.

Thank you.

[sunny_talwar · Accepted solution]

Check this out

[shraddha6369]

Thank you so much for the quick reply. It worked as per my requirement.