I'm working with a crosstab report displaying summary accounts on each row & current and prior year on each column. I'd like to create a drill down function for each of the summary accounts rows so that when I click on a summary account, the dept# that made up this summary total will be displayed either on a separate report or below the summary account that I click.
Any help would be greatly appreciated. Thank you.
This is what I want to create:
SUMMARY ACCOUNT FY2014 FY2013
600001 - SALARIES 500 380 (i.e. able to drill down to dept below when 600001 is clicked)
701000 - ER DEPT 200 175
757000 - CATH LAB 150 210
848000 - INFO SYSTEM 100 65
851000 - ACCOUNTING 50 50
710002 - BENEFITS 150 140
881000 - HUMAN RES 135 130
900000 - OTHERS 15 10
711003 - SUPPLIES XXX XXX