Crosstabs with Column Headers

aka How to make Crosstabs that look like lists

                     | sales
------+--------------+---------
branch| sales person | <1234>
      +--------------+---------
      | sales person | <1234>

will look like

                     | sales 
-----------+---------+--------
1st Avenue | Aaron A | 1,000
           +---------+--------
           | Betty B | 2,000
-----------+---------+--------
2nd Street | Clare C | 1,500 
...

If it was a list it would have column headers and would look like this:

branch     | sales person | sales 
-----------+--------------+--------
1st Avenue | Aaron A      | 1,000
           +--------------+--------
           | Betty B      | 2,000
-----------+--------------+--------
2nd Street | Clare C      | 1,500 
...

To achieve this using a crosstab you need to add extra Text Items and hide some cells by setting their box type to ``none''

    HIDE             | "branch" | "sales person" | sales
---------------------+----------+----------------+------
branch| sales person |  HIDE    |   HIDE         | <1234>
      +--------------+----------+----------------+-------
      | sales person |  HIDE    |   HIDE         | <1234>

Hiding the top left corner will pull the extra Text Items to the left so that the "headers" will nicely align with their columns.
But adding these new text item still creates extra empty columns in the crosstab... these have to be hidden as well.

The resulting crosstab will look just like a list, displaying column headers.

You may need to play around with styling it to get everything in the right color....