![]() |
|
#1
|
|||
|
|||
|
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 |
|
|
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 |