Summary Page

[GretchenRW]

I'm trying to build a report that ties many different sources of data together with no direct common data points. All of these individual pieces are important on their own, but need to stack to create 1 Large data set for export to excel. I have been unable to get them into 1 set since there is no overlapping comonality ( All of my data is customer, plant and item specific and none of my data sources contain all 3), but I would like to create 1 page (almost like a landing page) at the end of the report that pulls all of the smaller individual tables into 1 place with all of the settings that the user has applied throughout the report.

For example:

Page 1 : The customer and item were selected and table 1 shows the truck routes available for that customer. Table 2 Shows the price for different freight options for that customer/item combination. 

Page 2: Same Customer and Stock Number filters are applied from page 1. Table 1 Shows the overall cost to produce that item as reported by the plant. Table 2 Shows which plants actually produce that item.

Page 3: All of the tables from Pages 1 and 2 are shown with their current filters.

Is there a better way to do this?

Thank you so much for your help.

[newellaa · Accepted solution]

It seems someone needs to clean the source data before you can effectively filter on customer or item. 

[GretchenRW]

Newellaa, I agree 100%! There is data cleansing in process, but in the meantime I'm doing the best I can with what we have. I think that the synched slicers and landing page with multiple tables is the best I can do until the cleansing initiative has been completed.

[newellaa]

It seems that Customer and Item (or Stock Item) are common between the tables. You could create a concatenated field on each table of Customer and Item (CONCATENATE(Customer, Item). You can then join the tables on that field. If you have a customer table you could use that to join to each table. A query of the tables would show records for each customer/item with whatever fields that you want from the other tables. 

You can use the filters for all pages, synched slicers to apply customer item filters across the report.

[GretchenRW]

Unfortunately, not all of the tables I'm trying to pull in have Customer and not all of them have item. Also the ones that do, don't have standardized formatting (Some of my sources are spreadsheets vs SQL data) so everything is not apples to apples. Whenever I join large quantities of data are omitted. I was able to get the synched slicers to apply while I continue to fight the commonality issue.