View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default Pivot Table Data columns

Drag the Data button onto the Total cell, as described he

http://www.contextures.com/xlPivot02.html

Pele wrote:
I recently created a pivot table with two fields in the ROW section and I put
five (5)fields in the DATA column.

The problem is that all the five fields in the data section were put in one
single column as rows.

What can I do if I want 5 columns to show up in the DATA section. My final
goal is to show 12 columns in the DATA section for the 12 months of the year.

Can somebody help.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html