In SSAS in Excel it is possible in a pivot table to show "Visual Total" and not the total (Total). It's currently not possible in tables/matrix in Power Pivot - and should be...
Merged with
Matrix/Table grand totals with Measures