Pivot Table without a calculation?

[nancystorey]

Hi Everyone! I am trying to figure out something in pivot tables. My data looks like this:

DN x ST CPM

201204 0 NJ 0.00439

201204 1 NJ 0.00514

201204 2 NJ 0.00138

201204 3 NJ 0.0047

201204 4 NJ 0.00407

201204 5 NJ 0.00407

201204 6 NJ 0.00138

201204 7 NJ 0.00138

201204 8 NJ 0.00195

201204 9 NJ 0.00439


My pivot table takes the DN and the Max of the CPM column. I would like to have a column that will just pull in the ST, (all the States for all 10 DNs will be the same)... I can only see the options of count, sum, etc... Is there anyway I can just pull in the data without a calculation?


Thanks in advance!

 

[Luke M]

Add ST as another ROW field, under/right of the DN field. If you had different states, it would appear like so:

[pre]

Max of CPM
DN	ST	Total
201204	NJ	0.00514
IN	0.00407
Grand Total	0.00514

[/pre]

 

[nancystorey]

Thanks! I had to change my pivot table options for layout, but it works! Thanks again!