I have a webi report which have 2 query one for 2009 and second is for 2010 year data. Report have Division, Year and Customer as characteristic and cust_sales as key figure.
Requirement is to create 2 chart. One where we have division, year and cust_sales and second chart have Customer and cust_sales.
In second chart I want to show only Top 20 customer every time and did element linking from first to second chart. I want when user click 2009 and division "D1" second chart should show Top 20 Customer and cust_sales of same division and year and when user click on 2010 division "D1" or "D2" second chart show data accordingly. Second chart should show Top 20 cust_sales every time.
cust_sales is available as cust_sales2009 and cust_sales2010 since it is coming from two different queries.
Can it be done, if yes please guide.