Report with drill down details not working as expected
We have a requirement in reporting. one main report which should have drill down report.
Main report will display maximum salary in each department of an organization and drill down should display more details of the employee having maximum salary in specific department on which user tries to see the details.
Problem is we are getting all rows instead of the one having maximum salary in drill down report, as it is considering all rows which were used to find maximum salary.
Note: If we use 'count' summarize option in report it will work as expected, but 'Max' is not working as same.
Is it possible to define the drill down report or pass some filter criteria down to it to achieve this?
I'm interested in hearing more about how count worked, but max did not. If you drill down from a count... what record would this be drilling down to? Wouldn't this be all records which made up said count