Excel 2007 - Pivot Table Report Values fields

  • Thread starter Thread starter CK
  • Start date Start date
C

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.
 
Back
Top