C
cheerboy555
Data Source 'A': Customer monthly sales
Data fields: Cust_name, Apr 05, May 05, Jun 05, Jul 05
Data Source 'B': Customer Info
Data fields: Cust_name, Cust_ID, Cust_Group_ID
[Cust_ID is unique but Cust_Group_ID is not unique]
Task is to create a Pivot Table. Only Cust_Group_ID, Apr 05, May 05
Jun 05, Jul 05 are the data needed in the Table.
Theres more requirement, only those Cust_Group_ID = 100 200 and 300 ca
be shown in the table.
I know its easilier if the Customer monthly sales contain
Cust_Group_ID field. How can I select certain Data fields fro
different Data source and merge it together?
P.S. I have been thinking, do I have to Merge the required Data fiel
from different Data source together to create a new data source first
than create the Pivot Table.
P.S. I tried select "Multiple consolidation ranges" while creatin
Pivot table but it just merged the selected field from 2 data sourc
and still cannot sort those sales data of Cust_Group_ID = 100 200 an
300. please hel
Data fields: Cust_name, Apr 05, May 05, Jun 05, Jul 05
Data Source 'B': Customer Info
Data fields: Cust_name, Cust_ID, Cust_Group_ID
[Cust_ID is unique but Cust_Group_ID is not unique]
Task is to create a Pivot Table. Only Cust_Group_ID, Apr 05, May 05
Jun 05, Jul 05 are the data needed in the Table.
Theres more requirement, only those Cust_Group_ID = 100 200 and 300 ca
be shown in the table.
I know its easilier if the Customer monthly sales contain
Cust_Group_ID field. How can I select certain Data fields fro
different Data source and merge it together?
P.S. I have been thinking, do I have to Merge the required Data fiel
from different Data source together to create a new data source first
than create the Pivot Table.
P.S. I tried select "Multiple consolidation ranges" while creatin
Pivot table but it just merged the selected field from 2 data sourc
and still cannot sort those sales data of Cust_Group_ID = 100 200 an
300. please hel