how to get last 6 months value

[arulsettu]

hi

     i need to find last six month value but i have only year and month field alone.

i used this  sum({$<ACNT_FLEX_02={'Balance Sheet'},datefield={">=$(vPrior6)"}>}TBAL_MTD_DR_LC_1-TBAL_MTD_CR_LC_1)

vPrior6= AddMonths(max(datefield),-6)

datefield is MakeDate(TBAL_CAL_YEAR,TBAL_CAL_MONTH) as datefield

but i am not getting last six month values

please help

thanks

[anbu1984]

Check this

[arulsettu]

can you help me to implement this in my app i am doing in pivot table

[anbu1984]

vYear=Year(AddMonths(Date#(Only(TBAL_CAL_YEAR) & '/' & Only(TBAL_CAL_MONTH),'YYYY/MM'),-6))

vMonth=Date(AddMonths(Date#(Only(TBAL_CAL_YEAR) & '/' & Only(TBAL_CAL_MONTH),'YYYY/MM'),-6),'MM')

Expr: Sum({<TBAL_CAL_MONTH={'>=$(vMonth)'},TBAL_CAL_YEAR={$(vYear)}>}TBAL_MTD_DR_LC_1-TBAL_MTD_CR_LC_1)

[#5]

Then you make the 6 month in a extra dimension, simular as a Quartal. Then you could in the aplikation change the 6 month from 1 - 6 or 7-12.

[arulsettu]

only with in the field have to do no extra dimensions

[arulsettu]

i used below code results are coming but if i select 5th month it showing only blank values it should show previousw year 12th month value

sum({$<ACNT_FLEX_02={'Balance Sheet'},TBAL_CAL_MONTH={$(=max(TBAL_CAL_MONTH)-6)},TBAL_CAL_YEAR={$(=max(TBAL_CAL_YEAR))}>}TBAL_MTD_DR_LC_1-TBAL_MTD_CR_LC_1)

what i am doing wrong here some one suggest  me please

thanks

[stevedark]

Responded to here: problem in set analysis

Steve

[anbu1984]

Check this app