Here I have to Connect 2 different DataSources 1 is SQL and 2nd EXCEL.
In My SQL Data source I have 1 table, In that Table, i have 10 columns, Column A,B,C,D,E,F,G,H,I,J,
In SQL Data Source I have One more Table, That Table contains 4 Columns B, C, K, L.
I have another data source EXCEL In that 3 Columns are their F, G, M.
Based On All data I created 9 worksheets. Based On 1st data source I created 5 worksheets, Based on 2nd data source created 2 worksheets (Graphs) and 3rd Data source Excel Based on that I created 2 worksheets. Total 9 worksheets i placed in one Dashboard.In Dashboard I Placed Filters as A,B,C,D,E,F,G,H,I,J. So here if click A Filter i need to see data changes in all 9 worksheets.How we can do this Task Please Explain me Step by Step.
Thanks and regards,
Here's some documentation on how to filter across data sources: