Top N Sales in Table with MultipleFields

[kmmqlick]

Hi All,

Thanks in Advance

I am facing problem with straight table, i am having dimensions Representative, Customer, Source and Measure Sum(Sales).I taken one straight table with all these fields. Now the issues is i want to see top 10 sales in that table. I need to place one slider to see dynamic Top N sales.(I limit all dimensions to fixed number but showing all sales values)

Representative	Customer	Source	State	Sum(Sales)

[lironbaram]

hi 
something like this should do the job:
if(rank(total sum(total <Representative,Customer,Source,State> Sales))<=10,sum(Sales),0)