Last 2 Quarters data

[simsondevadoss]

Hi ,

I have a requirement in which I have to take bring data only for the current and last  quarters . My quarters are like s1-2014, s2-2014,s3-2014 and s4-2014.

If my current quarter is s4-2014. I have to take only data for s4-2014 and s3-2014.

Thanks in advance.

Regards,

Simson

[carvalguil]

Something like this?

[#3]

Hi Simson

you have 2 ways to do it.

Either when you load your script you set a flag (flag = 1) for current and previous quarters
and then you use it in your expression or calculated dimension

Either you use a conditrion straight in calculated dimension ((or may be in expression, i don't know your needs) based on specific variables like for example

if (yourQuaterFieldName = $(CurrentQuarter) or yourQuaterFieldName = $(PreviousQuarter),  Expr)

you can use set analysis as well

best regards

Chris

[simsondevadoss]

Thanks for your reply.

I need to filter out in data model .

Regards,

Simson

[giakoum]

maybe the attached can help too :