I've been asked to make a "report" (what I'm envisioning to be a dashboard of sorts) using 6 different lists in the same site collection.
Each list is a different product and contains unique columns, but they also have a handful of columns in common. The report will be grouped by each of the 6 products, with approximately 8 fields to display per product.
I'm able to set up lists and views without a problem, but I'm not sure how to combine all of the data into a single view.
My initial thought is to create a new page with a Web Part that pulls all the data together, but I'm not sure how to pull multiple sources into one Web Part, or, more accurately, which Web Part to use.
Another potential option would be to create a dashboard with multiple list view Web Parts, and I looked at the Site Aggregator (a previous admin set up a page for each product with a list view), but the request is really to get all products/information into one view.
Question: How do I roll up data from 6 different lists into one view/webpart/dashboard?