Pivot table linking questions

[dmbohner]

I have 1 pivot table each on 2 worksheets in a workbook.

Worksheet / Pivot Table 1:
The first pivot table is a look up table, where the user can find the job number based on different slicers.

Worksheet / Pivot Table 2:
The second pivot table gives specific job costs associated to a selected job.

Issue:
Currently to view specific job costs (on pivot table 2) you must know the job number. You can look it up on worksheet 1, but then you have to switch back and forth between the two worksheets.

What I would like:
Is it possible to have it that if the user does not know the job number they can look it up on pivot table 1, then simply click on the job number in the pivot table. This would hopefully open the 2nd pivot table and show the specific job costs associated with that job. Basically I need to know if you can link dynamic data in one pivot table to search criteria for a second pivot table.

 

[RoryA]

Is this question actually related to PowerPivot, or just regular pivot tables?

 

[dmbohner]

I am using PowerPivot to create the pivot tables if that is what you mean.

 

[RoryA]

I was just checking as people sometimes post regular pivot table questions here by mistake. I think this is borderline as I think the solution won't actually relate to PowerPivot per se, even though they are PP tables.

You could use a worksheet_pivottableupdate event on sheet 1 to automatically filter the pivot on sheet 2, or perhaps even just use the slicers to control both pivots. Hard to say without knowing the specifics of the table layouts. Can you put a sample workbook up somewhere - e.g. SkyDrive, Dropbox etc.?