Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Check this out
Thank you so much for the quick reply. It worked as per my requirement.