Hi,
I’m new to this forum, so first of all, hello all.
I am building a dashboard with 3 components to it.
1 List Selector
2 Pie Chart
3 Combination Chart
I have 2 tables of data.
Table 1 Lists by product in column A and across row 1 by country giving sales data YTD
UK US France Germany
Prod A 10 10 15 20
Prod B 100 75 30 50
Table 2 Lists by Country and Product in columns A & B and by period in row 1
Jan Feb Mar Apr
UK Prod A 2 3 2 1
UK Prod B 2 1 1 4
US Prod A 1 2 1 2
US Prod B 1 1 1 1
Using the List builder to select products, I populate virtual table #1 by adding rows from Table one, the sum of which forms the data for my pie chart, sections by country.
Up to this point all is OK.
Now, my client wants to click on the pie chart to see the phased results in the combination chart (Jan Dec) of the products selected (list selector) in the country clicked on in the pie.
So, I have created another Virtual Table based on Table 2, populated by all the countrys data depending on what slice of the pie is clicked on, but I am unable to work out how to then filter this for only those products selected from the List Selector.
I am able to do it on a small scale using a simple Vlookup, however, as my Table 2 is 1,900 rows and populates Virtual Table #2 which is 200 rows, a vlookup just causes my Xcelsius to crash.
Can anyone offer some advice on how to achieve what Im trying to do?
Thanks
ben22777 (BOB member since 2009-09-09)