Forum Discussion
Summary Page
It seems someone needs to clean the source data before you can effectively filter on customer or item.
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.
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.