Forum Discussion
Can I show a count of 0 in a pivot table
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 ...
SergeiBaklan thanks for that. Unfortunately, the item, 'Show items with no data in rows' is grey in my case.
When I create the pivot, I checked, 'Add this data to the data model'. This enables the option mentioned.
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.
