How to delete blank cells from Pivot table

[SAKSHI_ROY]

Hi Team,

Hope you are doing well.

Sorry for Taking your valuable time.

But could you please help me with my Excel pivot Problem. I have a table which contain some blank cells. when i make a pivot table, it also take total of blank cells which and i want to to delete total of Blank cells from Pivot Table.

I am using excel 2016 version.

Please consider the attached sheet for your reference.

Hope yo hear from you soon.

Regards Sakshi Roy

[#2]

@SAKSHI_ROY I dare to say you can't. You'll have to delete the items with no Data field from the source table, if you don't want to use the pivot table filter.

[#3]

@SAKSHI_ROY 

Creating PivotTable add data to data model and in Power Pivot add calculated column to table:

Aggregate on this column instead of Values