Top 3 sales!!!!!!!!!!!!

[#1]

Hi All,

             I have a sales table and department table ...my question is i have to display top 3 sales in list box and write expression in front end dont want write in edit script

pls help me 

[MK_QSL]

Create a list box

write below in expression

IF(Aggr(Rank(SUM(Sales),4),Department)<=3, Department)

or

IF(Aggr(Rank(SUM(Sales),4),Department)<=3, SUM(Sales))

or

IF(Rank(SUM(Sales),4)<=3, SUM(Sales)

[Gysbert_Wassenaar]

Choose Expression for the listbox instead of a field and use as expression something like

aggr(only({<DepartmentID={'=rank(sum(SalesAmount))<=3'}>} DepartmentID),DepartmentID)

Replace DepartmentID and SalesAmount with the real field names of your document.

[#4]

Hi manesh ,

   thanku for rly

     when click in dept list object it will show the top sales in  sales object .

      i dont want like that just i want see the top 3 sales in list object only top 3

pls help me

[MK_QSL]

Top 3 Sales with respect to what? which field ?

[#6]

with respect dept in sales field