Report with drill down details not working as expected
Hi All,
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.
Can anyone help me in solving this issue.