I have a worksheet connecting to a simple excel file.
Column A contains sales in GBP
Column B containc sales in USD
I want to make a simple bar graph using the dimension of country and sales but use a quick filter to toggle between USD and GBP
You can create a parameter showing a) Sales - GBP and b) Sales - USD. Then create a calculated field as below:
If [ParameterName] = "Sales - GBP" THEN [Column A] ELSE [Column B] END
Use this calculated field in the columns/rows shelf to create the bar graph.