1 Reply Latest reply on Apr 26, 2017 1:49 PM by Virginia Corvid

    How Filters Work on Different Data Sources.

    Harsha R

      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,

      Harsha.