Currency conversion

[Rajesh31]

PLEASE HELP

Hi I have month column with values such as 1,2,3,4,5... , I have revenue column and USD column

for everymonth there is a USD rate such as 1 has 73,2 has 86 and so on 

I need to have a filter of local and USD , I created fiter but when I apply *USD because of mutiple values its not working for USD selection , I seek your help 

I have multiple revenue fields , so Iam looking for a single formula by selecting that fiter it will overlay on revenue feild and convert all to USD

@peterbergman @JordyWegman @MayilVahanan @Mark_Little @David_Friend @vinieme12 

[JordyWegman]

Hey @Rajesh31 ,

Please add some data. This is way easier for us to work with.

Jordy

Climber

[MayilVahanan · Accepted solution]

HI

If Month is not dimension, then try like below

=Sum(Aggr(Sum(Revenue)*USDRate, Month))

[Rajesh31]

@MayilVahanan  thank you , it works