View Single Post
 
Old 12-12-2013, 05:13 PM
differentdrummer differentdrummer is offline Windows XP Office 2007
Novice
 
Join Date: Nov 2013
Posts: 10
differentdrummer is on a distinguished road
Default 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
Reply With Quote