year limit in set analysis

[#1]

hi all,

I have data from the month of 2000 to 2011 but i want to show it in charts only from 2010 to 2011 (in set analysis).

any idea please

regards

[swuehl]

Use a set expression like

{<Year={2010,2011} >}

e.g. in sum({<Year={2010,2011}>} Sales) as expression, Year and Month as dimension

Is that what you need?

[its_anandrjs]

Hi Usha,

See the sample file on that in chart calculation i use the condition for Month and Year only for March and Year for 2010 and 2011. Use the sample for your applications and condition. I use for Month as well as Year for in a Set Analysis  code =Sum({<Year = {2010,2011}, Month = {'Mar'} >} value)

Hope this helps you.

Regards,

Anand

[thanomjit]

Please try

ILYear=2011

ILMonth=03

Expression :

  Sum(  {< Period = {">=$(=Date(AddMonths(Date#(ILYear&ILMonth&'01','YYYYMMDD') , -11 ),'YYYYMM') & '') <= $(=Date(AddMonths(Date#(ILYear&ILMonth&'01','YYYYMMDD') , 0 ),'YYYYMM') & '')"} >}  Amount)

Result :

Sum Amount from 201103 to 201004