I have a few fields having the data in the following format.
S. No.
Category
Val
1
A
2.5
2
A
1.6
3
B
3.9
4
C
4.5
5
D
4.6
6
A
4
7
B
2.3
8
D
3.6
9
E
2
10
C
1
A user would select a category first and then would enter a value in an input box. the input box value would be the max top records he wants to see in the report for the category based on the value of the field VAL.
eg. if he selects category A and enter a value 2, the records with S.No. 6 and 1 should be filtered as they have the highest value for the field VAL in category A.
I've added a sample file with the text boxes indicating what I want to achieve. I want to make this generic and not limited to one chart or list box. So I guess when a value is entered a trigger should filter the top records. I am not sure on how to do that. May be it requires aggr function or something.
