Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
pls have a look into this ,
how to achieve this in front end
i have t1 and t2 tables
t1 is having country and currency value ,where t2 is having rate and actual amount
here my requirement is
if i click on newcheck in currency_n then i should see that sum({<period={201703}>}actualamount)*sum({<period={201703}>}rate) which is avaliable in upper chart
but here the problem is if add cyrrency as dimenison i am getting the correct result ,but i dont want see currency in dimension ,if i hide also country a will come twice which is wrong
idealy it should give the value for a in result column 154.8 but it is giving 303.4 but when i add currency as dimenion am getting the correct value .
how to achieve this
please le me know for any clarification on requirement
Please find attached application
Please share some sample expected output.
Or try this
when u add currency as dimension u will get the data in chart is output
but same result I want with out currency as dimension
pls have a look into the chart and let me know anything required
Hi,
not sure what exactly your requirements are, but maybe you can use an aggr function like
= Sum(
Aggr(
if(currency_n<>'newcheck',sum({<period={201703}>}amount),sum({<period={201703}>}actualsamount)* sum({<period={201703}>}rate))
, country, currency)
)
Regards
Please share your exact output.
which measures i have to use amount or actual sale amount
Hi,
You can try calculating the sum at the script level.
Please refer the attached qvw file.
Thanks,
Pooja
it was working fine,
but i wanna do it in ui level,
because if months from ui selections like apr and jan
then apr month rate should multipy with jan actual amount .
if we do it in script level we cant achieve this (where actual amount multipy with same month amount rate)
Hi,
had you checked my answer and tried the expression in your Chart as "result"? As far as I understood you, it gives you the results you expect, 154,8 and 408, even if you remove the dimensions currency and country. And it works in UI as you want. What other requirements you have, that not work with that solution?
Cheers
i will check and get back to u
Thanks