| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table - shows zero when should not be
Hi - I have a pivot table that is looking at a list in excel. It is basically
a summary of customer sales by product type. There are 26 customers and each customer has 26 product groups. I have the date at the top - month and year. Then I have the sale value in £ (as sum of). The first 5 customers are fine and return all data correct (so that is to row 130) after that, months that have any data show a zero BUT if you double click on cell it opens to show the lines and they are not zero but contain sales £ greater than 1. Is this due to too many lines in pivot? How can I correct this? -- Many thanks, Carrie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Top 20 pivot table shows more than 20 | Excel Discussion (Misc queries) | |||
| Looking for pivot table functionality that shows detail instead of count | Excel Discussion (Misc queries) | |||
| The last row of a pivot table shows blanks, but there is data. | Excel Worksheet Functions | |||
| How Do I create a table in excel that shows frequency? | Charts and Charting in Excel | |||
| Counting # of Times an Item Shows Up in a Table | Excel Worksheet Functions | |||
Threaded Mode
