2 Replies Latest reply on Nov 29, 2013 9:47 AM by Prashant Sharma

    Applying quick filter to multiple datasets from different sources without blending?

    Joe Lipski

      Hi all,

       

      I'm using two different datasources:

       

           1. Essentially store sales & catchment data about 300 different stores - (379,880 rows)

           2. The store catchments as polygons again about 300 different stores - (2,966,635 rows)

       

      I have am currently creating the dashboard below and want to have one filter to chose the store, however this issues I'm having with this are:

       

           - I cannot join the data and use in this way as it takes too long to join because of the size of each datasource

           - In the dashboard I therefore cannot apply one filter to the other worksheet


      Is there a way to update filter 2 with whatever is selected in filter 1?

       

      I'm not sure if this is the best way to achieve this so any advice would be greatly appreciated.

       

      Many thanks,

      Joe