2 Replies Latest reply on Apr 12, 2018 9:36 AM by Colleen Reynolds

    inner join between 2 data sources for 1 of several worksheets

    Colleen Reynolds

      My requirement is to use a SQL database that has 2 tables to create a series of dashboards.


      For some worksheets I only need to use the 1 main SQL table but for a couple scenarios I need to have an inner join between the 2 tables to create the graph for a dashboard.


      When I try to update the data source for the one worksheet to create the inner join it seems to be applied to all worksheets which i don't want.


      How can I limit my inner join requirement to just certain worksheets?


      I would appreciate any suggestions.


      Thank you.