Hide Total and Grand Total in the Cube browser

Many a times, people ask the question on how to disable or hide the Total and Grand Total rows in the result set when using the Cube Browser in SSMS (SQL Server Management Studio).

Here is a quick way to do that

When you browse a cube, you see Totals as below

Click on the dimension header in the Row Fields area

Right-click the highlighted region to bring up the menu as

Uncheck the Subtotal, and voila – it disappears
 

For more, just repeat the above steps