Question: why pivot table shows blank?
Answer: When a field is used in an excel pivot table, and there is not any data the field will display with the word 'blank'. Click in one of the cells that have the word 'blank'. Select the space bar, then tab on your keyboard. Repeat for each field that is displaying the word 'blank'.