Cumulative and Exchange rate

[#1]

Hi all,

if the user selects the Apr month, then i need to show the cumulative value from jan to Apr., then that value is multiplied by the Apr month Exchange amt.

i done that one by using set analysis.

but my problem is , if the user selects mar and Apr, then i need to show two column one is for Mar and another one is for Apr.

in Mar, cumulative value from Jan-Mar then multiplied by the mar month Exchange rate,

in Apr, cumulative value from Jan-Apr then multiplied by the Apr month Exchange rate,

could anyone help me to solve this issue...

thanks in advance....

[#2]

Hi,

i m using the following expression

Sum({<Num_Select_YearMonth={'<=$(=max(Num_Select_YearMonth))'},

                                        Select_Year={$(=MaxString(Select_Year))},

                                        Ex_MonthYear={'$(=max(Select_YearMonth))'}

                              >}Amt* Exchange_Amt_Avg)

Its working fine to see only one month...

but i dont know how to do for multiple months, based on the month selection...

Could anyone help me to solve this issue...

thanks in advance...