Forum Discussion

tscott3334's avatar
tscott3334
Regular Visitor
10 years ago

Help on linking Slicer with different query

Currently I am trying to use one slicer to filter on two queries within the same report that controls a graph. 

 

Forecast Query, has a column "CC 2" and Actuals Query has  a Company Code column, they both have the same values with in them (1000, 2030, & 2090). 

 

The graph is a bar and line graph.  The bars are pulling from Actuals and the line is pulling from Forecast, when selecting the slicer to filter on"1000" I would like both the line and bar graph to updated.  Currently I have to have 2 slicers and select a "1000" on both for the bar and line graph to update.

 

Pleaseee Help.

 

Thanks!!

 

 

 

No RepliesBe the first to reply