1 Reply Latest reply: Mar 21, 2013 4:19 AM by Satya Ranki Reddy RSS

    How to get top 10 records for each option in table prompt?

    986267
      Hi,

      I have created one report in which my requirement is to get top 10 highest salaries for each departments. I have created one table prompt which contains the names of all departments. On the salary column I have applied one filter i.e. TOP 10. Currently I am having 3 departments. I want to show the top 10 salaries for each department, but I am getting top 3 from first, 4 from second and 3 from third.They are calculating top 10 salaries based on all departments, not on individual department. How can I get top 10 salaries for each department?