Hello All,
I was wondering if I could get some help linking two pivot tables then filtering a consistent value with a single slicer. Here are the criteria:
In the attached example workbook I have two data tables on different sheets. This can be switched to have all data tables on one sheet if necessary.
The data tables cannot be combined with one on top of the other, in the actual data, the tables are added to every day.
The common field in the Job Number. This also needs to be the report filter for the pivot table.
The data in each row (Columns A:M) is inherent to that job number.
With one slicer for the job number, I need to know total issues per job, noted in column K. Example: Job 1 has 10 total issues, 5 per table.
Just as a note, I need to link 20 tables that will have a maximum of 20K rows of data per table in my actual data.
Thanks!
Bookmarks