Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
HI
If Month is not dimension, then try like below
=Sum(Aggr(Sum(Revenue)*USDRate, Month))
Hey @Rajesh31 ,
Please add some data. This is way easier for us to work with.
Jordy
Climber
HI
If Month is not dimension, then try like below
=Sum(Aggr(Sum(Revenue)*USDRate, Month))
@MayilVahanan thank you , it works