Based on Two individual calender prompts ,two individual columns must change?

ARIVEMULA KAVYA KUMARI, LERA TECHNOLOGY PVT LTD

Hi,

I have created two presentation variables @{OSM_007_CME@} for current month end column, @{OSM_007_PME} for previous month end column.

one calender prompt for current month end:

TIMESTAMPADD(SQL_TSI_DAY,DAYOFMONTH(MAX("GL_BAL_CRF"."BUSINESS_DATE")) * -1 , TIMESTAMPADD(SQL_TSI_MONTH, 1, MAX("GL_BAL_CRF"."BUSINESS_DATE")))

second calender prompt for previous month end:

TIMESTAMPADD(SQL_TSI_DAY,DAYOFMONTH(TIMESTAMPADD(SQL_TSI_DAY,DAYOFMONTH(MAX("GL_BAL_CRF"."BUSINESS_DATE")) * -1 , TIMESTAMPADD(SQL_TSI_MONTH, 1, MAX("GL_BAL_CRF"."BUSINESS_DATE")))) * -1 , TIMESTAMPADD(SQL_TSI_MONTH, 0, TIMESTAMPADD(SQL_TSI_DAY,DAYOFMONTH(MAX("GL_BAL_CRF"."BUSINESS_DATE")) * -1 , TIMESTAMPADD(SQL_TSI_MONTH, 1, MAX("GL_BAL_CRF"."BUSINESS_DATE")))))

In my report,3 columns are there current month end, previous month end, growth rate.

in current month end column : i put formula like;

{OSM_007_CME}))))

in previous month end column : i put formula like;

FILTER(IFNULL("GL_BAL_CRF"."LCY_BALANCE",0) USING (MONTH("GL_BAL_CRF"."BUSINESS_DATE") IN (MONTH(@{OSM_007_PME}))))

Please see the below scree shots

I am getting data when i select 1st calender : oct-31-2015 & 2nd calender : sep-30-2015

in my database, october month data  only ..

My requirement is,  I am not getting data when i select 1st calender : nov-30-2015 & 2nd calender : oct-31-2015.

october data not getting in second column (i.e previous month end). that means 1st column has november data..

I have tried so many times..please help me

Thanks in advance

A.kavya