Pivot Table

[Sandip Shah]

Hi,

I am having a problem with respect to a Pivot Table. The data sheet
contains around 40,000 lines and I am comparing Sep-03 data with
Dec-02 for various accounts through a Pivot table. The data for Sep-03
and Dec-02 are in separate columns in the Excel sheet.

Problem 1 :

When I move either Sep-03 or Dec-02 (any one of them) into the data
within the Pivot table, I get perfect listing. However I want to move
both the columns and have a comparison. As soon as I move both the
columns into the data area within the Pivot table, I donot get a
comparison but the data for each account comes below one another. How
do I get the figures in 2 separate columns for the same account codes.

Appreciate someone's help.

Regards
Sandip

 

[Debra Dalgleish]

1. Point to the grey button for the Data field
2. Drag the Data button onto the cell that contains the word 'Total'
3. Release the mouse button

There is a picture of this procedure here:

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