If you have pivoted any dimensions to column headings, you can total the rows using partial sums. If you have no dimensions in the column headings (ie only expressions), then the partial sum does not work. Instead, you can total the rows by creating a total expression that adds the columns:
=Column(1) + Column(2) + Column(3) .....
Hope that helps