How can we link the trend line sheet with other two sheets


Problem

Let's assume we have a "product performance analysis" dashboard. In this dashboard, we imported a worksheet named "average product revenue per year" showing the yearly trend. We also imported two other worksheets/charts into this dashboard. When we click on any point/year on the line chart (average product revenue per year chart), it does not filter the data in the other two sheets accordingly. How can we link the trend line sheet (average product revenue per year chart) with the other two sheets to filter the data as per selected point/year on the trend line?

Request for Solution File

Ask an Expert for Answer!!
Financial Accounting: How can we link the trend line sheet with other two sheets
Reference No:- TGS03280752

Expected delivery within 24 Hours