Pivot table - I cant display item labels when no fields in value area
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
|