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