Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a filter pane which consists of employee names,
and also a table to show the top 5sales from the selected employee.
i've tried using
Sum({<Employee= {'=Rank(Sum(Sales)) <=5'}>}Sales)
but all i get was one column in my table.
Thank you.
Edited (I have included a sample data)
PFA