filter pane to show top 5

[sanpor1zd]

hello,

i have a filter pane with the employees name,

and a table with their sales transaction figures.

im trying to show the top 5 sales figure for each employee. so whenever i select an employee, the table should show the top 5 sales figures. 

i tried using Sum({<Sales= {"=Rank(Sales) <=5"}>}Sales), but it only returns one result

attached is my sample. 

thank you. 

[Kashyap_R]

Hi

please go thru the attached QVF

hope this helps

thanks

[sanpor1zd]

Hi Kashyap,

your solution works great!

however, when i apply your solution to my current project, i dont understand why it couldnt work. 

ive attached an edited project of mine for your reference. 

im trying to show the top 5 prices for each zip code. 

thank you so much! 

[Kashyap_R]

Hi 

Try this some function works for some scenarios

Hope this helps

Thanks

[sanpor1zd]

Any other ways ? 

ive tried

IF(COUNT(GetCurrentSelections(Zipcode))=1,
if(Rank(Price)<=5,Zipcode),Zipcode)

but the results only rank the price from the highest to the lowest, but did not filter the results to top 5. 

[Kashyap_R · Accepted solution]

Hi

Try this

=if((GetSelectedCount(Zipcode))=1,if(Rank(Price)<=5,Zipcode),Zipcode)

Hope this helps

Thanks

[sanpor1zd]

You are the best 🙂