Using a numeric field as a row in a CrossTab is not working, at least in my report. Am I doing something wrong or is this not possible?

For example: I want to know the number of transactions with $50, $100, $150, etc. broken down (column) by type of transaction (i.e. "Cash", "Credit Card", etc.)

The report works if the transaction type is the row and the amount is the column, but not the other way around.