How to collapse rows and columns in Pivot table

Feb 22, 2014 at 12:14 PM

Is there any way to collapse row and column in Pivot table.

It can be easy done by using excel macro

pivotfields("name").ShowDetails = false

I know we can write macro and create xlsm file, I do not want to do it.