#1
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel Pivot - Do not display rows with zero value | patidallas22 | Excel | 1 | 03-08-2013 01:35 PM |
Help with a pivot table please! | natsha | Excel | 1 | 02-16-2012 12:41 PM |
How to display sort fields | keith1952 | Word | 1 | 10-31-2011 05:58 AM |
Pivot Table | Karen615 | Excel | 5 | 08-03-2011 10:46 AM |
Pivot Table's fields | janis129 | Excel | 7 | 03-02-2010 03:16 PM |