Skip to Content
0
Apr 15, 2014 at 06:52 PM

Drill down in crosstab report

78 Views


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