Reg-historical month display

[#1]

Hi Team ,

i have attached the expression please find the attached .

i have straight table report andi have filters as month.if i select current month the data is coming correct and if i select the previous month iam getting zero values for the YTD%ACH,YTD%ARCHF1 for the coloumns.Please can any one help me out

[maximiliano_vel]

Perhaps if you exclude the Period in the set analysis?

(sum({<Year={$(vCurrentYear)},datasource={'DKSH','DKSH-CG','ZUELLIG-PASTEUR'},Country_Name={'Malaysia'},Invdate={">=$(=vStartDateMYBN) <=$(=vDownloadDate)"}, Period>}salesvalue/Rate))