
The simplest row axis you can have is member(s) from one dimension in one column like this:

In this case we have Revenue, COGS (Cost of Goods Sold) and GP (Gross Profit) which are all in the Accounts dimension.
You do not need to have them all in adjacent cells. That is, you can spread them out like this:

This is useful if you need to put your own Microsoft Office Excel formulas or annotations in between the report lines.