Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
sanpor1zd
Contributor II
Contributor II

Filter pane and set analysis table for top 5.

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)

10 Replies
tresesco
MVP
MVP

PFA