pivot table display items with no data pivot table with text in values area pivot table with text in values area pivot table display items with no data pivot table display items with no data pivot table non numeric values excel pivottable value fields pivot table count blanks exceljet percenes of in excel pivot tables the excel amount column i had convert empty field in an excel pivot table excel pivot tables ms excel pivot table deleted items