Condition to Display only last 4 month.

[berryandcherry6]

Hi,

I am trying to display only last 4 months.

so for thaat I have Canonical_Month in script, which contains all 2015 and 2016 months.

LOAD

    Date(CanonicalDate, 'MM-DD-YYYY') AS CanonicalDate,

Month(CanonicalDate) As Canonical_Month;

Now i need only last 4 months irrespective of year.

How could i do this? Any help is appreciated

[kaushiknsolanki · Accepted solution]

Hi,

You can use the Where condition to restrict your data.

After From or Resident statement you should use Where condition like below.

Load *

From XYZ

where CanonicalDate >= addmonths(today(),-4);

Regards,

Kaushik Solanki

[berryandcherry6]

Hi,

Thanks for reply

If i need to apply this condition in front end of  Dimension. How could i restrict data in dimension instead of  in script using where condition.

Could that be done?

[kaushiknsolanki]

Hi,

In front end you should use the set analysis.

Your expression will become.

Sum({<Date = {">=$(=Addmonths(Max(Date),-4))"}>}Sales)

Regards,

Kaushik Solanki