Excel 2007 - Pivot Table Report Values fields

[CK]

I have a pivot report that has the format below:
-------------------------------------------------------
| | Col1 | Col2 | Col3 | Col4 |
------------------------------------------------------
| Row1 | Row2 | Val1 | Val2 | Val3 | Val4 |
-------------------------------------------------------

I would like to ensure that the Val1..4 field values are not summarized
since there is only one for each row. I would like to show the actual value
but do not seem to have the option in excel 2007. Please let me know if you
have any ideas on how I can accomplish this.

Thanks,

Chris.

 

[Roger Govier]

Hi

Double click on Row 1>Subtotals>None
Same for Row 2