S
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
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