General Ledger
Active Member
- Joined
- Dec 31, 2007
- Messages
- 460
Dear All,
I have been using PowerPivot for about an hour so please forgive my lack of understanding. Using Excel 2010 with Windows 7 Professional.
I want to create a PivotTable on data from multiple databases that have the same tables and field names. What options might be available to do this?
I have a SQL connection to the database of my ERP. I have been able to add tables and create relationships. For example, I added a table of Invoices and created a relationship to the Customer table based on the Customer ID field. Now I have Invoice records with Customer Names. Great!
I use my ERP for three companies and therefore have three databases. The three databases have the identical table and field names.
I want to:
1. Link the invoice table to the customer table for each database (Company A invoices to Company A customers, Company B invoices to Company B customers, and Company C invoices to Company C customers).
2. Tag each record with a Company identifier (A, B, or C) so I know which Company the record is from.
3. Combine all the invoice records into one table.
4. Create a PivotTable on the combined table.
As I wrote, I am very new to PowerPivot so please be explicit with any responses.
Thank you very much,
GL
I have been using PowerPivot for about an hour so please forgive my lack of understanding. Using Excel 2010 with Windows 7 Professional.
I want to create a PivotTable on data from multiple databases that have the same tables and field names. What options might be available to do this?
I have a SQL connection to the database of my ERP. I have been able to add tables and create relationships. For example, I added a table of Invoices and created a relationship to the Customer table based on the Customer ID field. Now I have Invoice records with Customer Names. Great!
I use my ERP for three companies and therefore have three databases. The three databases have the identical table and field names.
I want to:
1. Link the invoice table to the customer table for each database (Company A invoices to Company A customers, Company B invoices to Company B customers, and Company C invoices to Company C customers).
2. Tag each record with a Company identifier (A, B, or C) so I know which Company the record is from.
3. Combine all the invoice records into one table.
4. Create a PivotTable on the combined table.
As I wrote, I am very new to PowerPivot so please be explicit with any responses.
Thank you very much,
GL
