Here's the steps :
- Create a parameter to choose between USD & local
- Create a calculated field called Value
- the equation for Value is
if parameter = "USD" then [Total Value USD]
else [Total Value Local'
use the calculated field in your view and you're done
Thanks McClellan, it's really useful.... is this possible to change the Dollar column based on the selection through Action filter? if yes, please help me here.
In the recent versions it might be. Can you create a new topic for your situation and post a workbook of what you've done so far ?
Sure, let me create a new topic on this. thanks.