Pivot Source Data Blanks

[Kellyscoffee]

Hi, when generating a pivot table from a column of source data, is it possible to ignore cells with blanks in? To stop another blank column being generated when the pivot table range data is set. My workbook contains 3 columns and when Col B is not populated with a P value the adjacent cell wording is populated with the word Clear, i want to display solely the Clear total and not include the blank column. Thanks in advance.