Clean values in a Pivot Desk look pointless and they are often distracting. You will see under the steps to cover Blanks in Pivot Desk.
Cover Blanks in a Pivot Desk
While you create a Pivot Desk and the supply knowledge accommodates empty cells, the empty cells are reported as “Clean” within the pivot desk.
Relying on the group of your Pivot Desk, the Blanks can seem in Rows, Columns or in each Columns and Rows.
Normally, “clean” in a Pivot Desk serve no function in any respect and you may simply Cover Blanks in Pivot Desk by following the steps under.
1. The primary steps is to establish the Clean values that you simply need to cover in a Pivot Desk. In our case, we’ve got Blanks each in Row and Column of Pivot Desk and so they serve no function.
2. To cover blanks in Pivot Desk Rows, click on on the Down-arrow situated subsequent to “Row Labels”. Within the drop-down, uncheck the little field situated subsequent to clean and click on on the OK button.
This can cover the Clean showing in Pivot Desk Rows. Relying on the Format of your Pivot Desk, this step may cover the Clean showing in Pivot Desk Columns.
3. When you nonetheless discover Clean showing in Pivot Desk Column, click on on the Down-arrow situated subsequent to “Column Labels” and Uncheck the little field situated subsequent to Clean within the drop-down menu.
4. From now, each time the Amount is clean in date supply, the info won’t be reported as “Clean” within the Pivot Desk.
- Find out how to Create Two Pivot Tables in Single Worksheet
- Find out how to Add or Take away Subtotals in Pivot Desk
Me llamo Javier Chirinos y soy un apasionado de la tecnología. Desde que tengo uso de razón me aficioné a los ordenadores y los videojuegos y esa afición terminó en un trabajo.
Llevo más de 15 años publicando sobre tecnología y gadgets en Internet, especialmente en mundobytes.com
También soy experto en comunicación y marketing online y tengo conocimientos en desarrollo en WordPress.