Blanks in Pivot Table

[Puneet]

Hi

I have some data where some of the values in the last column column are blank. When I create a pivot table it shows blank. If I filter Pivot table removing blanks It removes the entire Row. Can anyone help me in this?

Thanks
Puneet

 

[Somendra Misra]

@Puneet

It will be more helpful for the readers and you also if you upload a sample workbook with data and problem.

Regards,

 

[SirJB7]

Hi, Puneet!
I'm afraid that it's not possible to achieve what you want. Pivot Tables deal with the existing data, if it's blank they'll display blank. And if you filter by a column value, all the columns or the involved row are excluded/included depending on that column cell value.
Regards!