Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Looking for something like this?
Script:
Table:
LOAD Group,
value
FROM
(ooxml, embedded labels, table is Sheet1);
Join(Table)
LOAD Group,
value,
AutoNumber(value) as Rank
Resident Table
Order By value desc;
On the front end create a straight table with:
Dimensions: Group, Rank
Expression: =Sum({<Rank = {'<=5'}>}value)
