topic Re: Sorting in Table ( Top three based on a Measure and group by Dimension) in App Development

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

shraddha6369 — Thu, 18 Apr 2019 12:53:21 GMT

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 — Thu, 18 Apr 2019 13:32:18 GMT

Check this out

shraddha6369 — Thu, 18 Apr 2019 13:58:53 GMT

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