ODS Excel Dynamic display of row data

[JKramer]

I believe it's possible to create an excel spreadsheet from ODS Excel that would allow the end user of the report to collapse or display rows as needed. It would look something like the table below. One user could request to just see the totals by study; or by study and site; or by the study, site and subject by clicking on an object on the spreadsheet. If this is possible, what would need to be added to my proc report code?

[Ksharp]

/*You could try "AutoFilter" option:*/
ods excel file='c:\temp\temp.xlsx' options(AutoFilter='all');
proc report data=sashelp.class nowd;run;
ods excel close;