Hi,
I have a project at work that I really need help with. The file uses PowerPivot by bringing in five different Access Database files. I believe this is done by updating the data connections in PowerPivot. However, I don't understand how all the different reports are connected to ultimately create a final consolidated pivot / report / analysis. These reports have different fields and headings but each report has at least one field that is exactly the same (a unique identifier). Can you show me how the reports or tables are connected? I believe keys were setup from each of the reports. It's really hard for me to explain so i was wondering would it be possible to get on TeamViewer so that i can show someone and get some help? I'd really appreciate it. Thank you so much.
Regards,
Tawny
Bookmarks