Browse » Home
Sunday, January 15, 2012
How to Remove Blanks From Pivot Table
1.
Select any box within the pivot table report to activate the PivotTable toolbar. Click the 'Refresh Data' icon.
2.
Click on the data field drop-down list in the first column of the pivot table. Uncheck the box next to the '(blank)' option. Click 'OK.'
3. If there is another data field drop-down list in the same column, select it and uncheck the box next to the '(blank)' option. Click 'OK'. Repeat this step until all data fields in the column have all of their '(blank)' filtering options unchecked.
4.
Select the first data field drop-down list in the first row of the pivot table and uncheck the '(blank)' filtering sort options.
5.
Repeat Step 4 for each and every data field that has drop-down filtering list.