I
Irene Chew
I have a total of 3 worksheets that get the data from a Access
database queries. Basically, the query in the Access database are the
same, meaning that the column name are identical, therefore, the label
name returned are all the same, except that the rows retrieved in
these 3 queries are different.
I tried to create a Pivot table using the option - 'Multiple
Consolidation Ranges' in Step 1 of 3 of the Pivot Wiazard and selected
these 3 worksheets and the ranges. However, at the Wizard layout of my
Pivot table, i noticed that it does not gives me each column's label
name, instead, all my columns are grouped under a label called column
with all the label name under this column called - 'column'.
If i select just 1 of the single worksheet, and i can get the column
label name displayed properly in the Pivot Table Layout wizard. What
is the cause, pls help.
database queries. Basically, the query in the Access database are the
same, meaning that the column name are identical, therefore, the label
name returned are all the same, except that the rows retrieved in
these 3 queries are different.
I tried to create a Pivot table using the option - 'Multiple
Consolidation Ranges' in Step 1 of 3 of the Pivot Wiazard and selected
these 3 worksheets and the ranges. However, at the Wizard layout of my
Pivot table, i noticed that it does not gives me each column's label
name, instead, all my columns are grouped under a label called column
with all the label name under this column called - 'column'.
If i select just 1 of the single worksheet, and i can get the column
label name displayed properly in the Pivot Table Layout wizard. What
is the cause, pls help.