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,