Pivot Table Data columns

[Guest]

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.

 

[Guest]

I am completely lost. Post some details, specifically what does your source
data look like and what does your pivot table look like... Copy and paste if
that is feasable...

 

[Debra Dalgleish]

Drag the Data button onto the Total cell, as described here:

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

 

[Guest]

Debra,

THANK YOU very much....

Drag the Data button onto the Total cell, as described here:

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