1. Create a pivot table with two dimensions:
and one expression
2. Expand the first column of the pivot table.
3. Drag the second column of the pivot table to above the expression column (sometimes this is a little tricky to do) and when a horizontal blue arrow appears let go of the mouse.
4. You have your report.