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