| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pivot Table not populating cells
I have a set of data which I need to put into a PT: Level 1 is Surname and
level 2 is First Name. I've sorted it within the PT by Surname then First name. I have 15 instances of the name Jones. When the PT is produced it only shows one instance of th word Jones and then the rest of the lines below (ie the other 14) have no data. The next column to the right has all 15 First names but the only one with Jones next to it, is the first one. How can I get my PT to show ALL surnames next to all the first names please? Thanks in advance, AW |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Size | Charts and Charting in Excel | |||
| OLAP Pivot table - How to show items with no data ? | Excel Worksheet Functions | |||
| Pivot Table keep apart cells text that I've formatted as numbers | Excel Worksheet Functions | |||
| Excel - pivot table - how do i format cells with data mm/dd/yyyy . | Excel Worksheet Functions | |||
| Counting blank cells in Pivot Table | Excel Worksheet Functions | |||
Threaded Mode
