Remove Repeating Values in a Table Visualization

Colleagues, 

The solution provided does work, but there is one problem with it:  The Matrix View does not appear to allow Horizontal scrolling.  In my situation, there are more columns to display than there is space on the page.  With a table, I can scroll to the right.  In a matrix I cannot.

Am I missing a setting that does allow Horizontal scrolling in the Matrix View, or is there now some other way to use the Table Visual and remove repeating information?

thank you parry2k!   ... needed to familiarize myself with drill down feature of a matrix.

So now that there is a flattened table due to the Left Outer join (Merged within a Query), how does one limit the number on the many side of the table? Specifically, how does one limit the number of Activities for a given Lead to some # (say 2) (sorted by date in descending order.. there is a date field; just not show in the below matrix)?  

Thinking the # of Activities should be limited before the two tables are joined/merged.  The Activities table (the many table) is related to the Lead table via Lead-ID; each Activity record is uniquely identified by the Activity-ID, but there are multiple records with the same Lead-ID.  How would one list the Activities for a given Lead-ID in descending order by Activity-Date, and limit the number of Activity-IDs?

  In an Activities query, one could duplicate the Lead-ID and the Date fields, merge the two duplicated columns, and sort the merged column.  So one would have the list in descending order, but what isn't clear, assuming this is even the correct path to take, is how to limit the number of Activities for a given Lead.