Aug 23 2021 07:22 AM
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
Aug 23 2021 07:37 AM
@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.
Aug 23 2021 01:48 PM
Creating PivotTable add data to data model and in Power Pivot add calculated column to table:
Aggregate on this column instead of Values