I have a table with customer name and # orders placed



In the pivot table I am displaying # orders (grouped) in the rows and then # orders again in the values area.

Orders Placed # customers
0-10 5
11-20 0
21-30 8
31-40 12

I want it to look las above

However what I get is (ie the row "11-20 0" is missing )
Orders Placed # customers
0-10 5
21-30 8
31-40 12

I thought that pivot table options -> display -> "display item labels when no fields are in value area" would fix this but its greyed-out .. the strange thing is that it's greyed out with the tick ON

Can anyone shed some light on this ? Thanks in advance