The issue for our application is that sometimes there's just too much data. If I have a matrix of information that is 25 columns by 100 rows, I don't have a lot of choices but to scroll horizontally. Drilldown is taken off the table by the fact that the information must be available for quick cross-reference.
Our issue is not unique. Lots of people solving business process problems face this issue, and I'm not aware of any good solutions. I'm ready and willing to be educated though. Even if an alternate solution is harder, we're not afraid of putting in the extra effort. We have a base set of requirements to meet though:
* Must accommodate variable record counts in the x and y axis
* Must make data available for quick cross-reference (moving in and out of sub-screens to compare data is not acceptable)
* Must maintain the x and y axis relationship of data; that is to say, collapsing columns or rows is fine, but shuffling is not
We experimented with an option that collapses columns, but at some point, even collapsed columns take up too much space. This means moving them out to a separate "column selection" widget, which limits the maximum number of selections and is even more confusing for users than horizontal scrolling.
Not an easy problem to solve.