Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I have a chart that has a list of countries (that are determined where X and Y are on a particular chart).
Example: USA has X=20 and Y= 180. This is just a visual representation of where a particular country is on my chart.
I have another list generated from a database that is a company, and within that company, it has many countries relating to it. I was wondering if there was some way that if I select that company, it would display the selected countries associated with that company.
Database looks something like:
Company Country
Company A USA
Company A USA
Company A China
Company A Mexico
Excel sheet looks something like this:
X Y Country name:
20 180 USA
14 -180 China
15 163 Mexico
So if I select company A, the countries USA, China, and Mexico would display.
Any help would be awesome !
Thanks!
Create a chart or straight/pivot table with Country name as dimension. Add a listbox with Company as field. As soon as you select a companie in the listbox the countries for that company will be shown in the chart or straight/pivot table.
Create a chart or straight/pivot table with Country name as dimension. Add a listbox with Company as field. As soon as you select a companie in the listbox the countries for that company will be shown in the chart or straight/pivot table.
Thank you!