We currently maintain an annual data set for 200 countries with a number of fields set in pounds sterling.
For the first time, we have been asked to provide the data in different currencies
Is there a simple and elegant way that I can set this up so that I can use a filter box to switch the views on each tab between a limited number of currencies?
That's what the variables are for... You could create a text choice variable "Currency choice", where users could use the radio button to switch between GBP, EUR, USD etc., then add a formula field that will contain a nested IF statement, with calculation for each currency choice. Please see a demo in this forum post: http://forums.visokio.com/discussion/1002