Hi All,
i need to display some calculation like:
sum of Amount where country USA/ Sum of Amount where Country none USA based on reference ID's
Aggr(Sum({<Country={"USA"}>}Amount)/Sum({<Country-={"USA"}>}Amount),[reference ID]),
Aggr(Sum({<Country={"USA"}>}Amount),[Reference ID])/Aggr(Sum({<Country-={"USA"}>}Amount),[Reference ID])
i have written both the Expressions but didn't give the results
Note: in that report apport from reference Id, Name, Country,date fields are also there
Please suggest me any good expression
Thanks in Advance
