Element Linking and Hide/Show help in webi
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.
First you have to merge the dimensions from both providers
1. Create the chart 1 division in category axis and sales in value axis
2.create the chart 2 provide customer in category axis and sales in value axis
3. create a variable provide the Rank(Measure; top; (Division));
4. create a link between these 2 charts,chart 1 add element and select the dimension.
Assign the report elements(chart 2)
5. provide a filter in chart 2 to show the top 10(Rank <=10)