How do I link a list box (Currency - USD & Local) to charts and tables already in a dashboard that has Gross/Net Premium & Brokerage for a number of countries?
The Gross/Net Premium & Brokerage figures are in 'Base' (local currency for each country) and 'USD' which have been converted using monthly exchange rates which I upload via an Excel spreadsheet every month. I downloaded the Asset Management demo of this site, which is similar to what I need (in regards to currency logic) but cannot seem to be able to use the same logic in my dashboard.
Attached Asset Management QlikView demo for a reference.
