Apr 25 2021 06:24 PM
Let's assume my data is like this:
Category Details
Pens Super
Pens Mediocre
Pencils
Pivot will show
Pens 2
Pencils 1
I need to show Pencils as 0
Apr 25 2021 09:48 PM
@nilanprospecta Be sure that you are counting Details in the value field and that the cells that appear to be empty really are empty. A cell with a single space may look like a blank, but it will be included in a count as 1, just like you experienced it.
Apr 26 2021 02:12 AM
Right click on PivotTable and open PivotTable Options. Here check this setting
and show empty cells as zero
With that PivotTable looks like one at the bottom here:
Apr 26 2021 04:44 PM
@Sergei Baklan thanks for that. Unfortunately, the item, 'Show items with no data in rows' is grey in my case.
Apr 26 2021 05:07 PM
Apr 27 2021 03:43 AM
Yes, but without adding to data to data model it shall show rows with data in any case, that only to select show blanks as zero.
Anyway, glad to know you sorted this out.