I am trying to create filter on multiple datasource but not able to achieve this.
The datasouce are like this for example.
Datasource 1. PRODUCT YEAR AND SALES
PRODUCT1 2009 1000
PRODUCT1 2008 1200
PRODUCT2 2009 800
PRODUCT2 2008 700
Datasource 2. PRODUCT YEAR AND SALES
PRODUCT1 US 1000
PRODUCT1 UK 900
PRODUCT1 ITLAY 1200
PRODUCT2 US 1100
PRODUCT2 UK 800
PRODUCT2 ITLAY 750
I want to have a product filter on the top of dashboard to choose a single product and the two differnt charts should show the data only for that product.
I am able to do this using two components. But do not know how to use a single filter component to filter these two datasource.
Can you help on this ?