Skip to Content
0
Former Member
Jan 12, 2015 at 01:18 PM

Element Linking and Hide/Show help in webi

227 Views

Hi,

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.

Thanks,

Ankit