Forum Discussion
How to delete blank cells from Pivot table
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 Replies
Creating PivotTable add data to data model and in Power Pivot add calculated column to table:
Aggregate on this column instead of Values
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.
