"Show items with no data" does not work

[maunzDK]

Hi Community,

I have the following problem:

I cannot make my pivot table display rows for items without data.

I have tried two commonly proposed solutions, unfortunately both didn't do the trick:

1) Right click on the item in question -> Field settings -> Layout&Print -> Show items with no data (this one I have ticked but it doesnt help)
2) PivotTable Options -> Display -> Show items with no data on rows (this one is greyed out so that I cannot tick it)

I am using Excel 2010. Could anybody help me out? I've been searching the web for hours and havent found a solution

Many thanks in advance!

Best,
Martin

[Richard Buttrey]

Hi,

Any chance you could upload the workbook?

[maunzDK]

Hi Richard,

unfortunately not as it is since the data is confidential. If this is the only way I can be helped, I could replace the data with fantasy values though and upload the file.
Would just be quite an effort.

Best,
Martin