5 Replies Latest reply: Feb 6, 2015 5:17 AM by neetha P

# dimension limits display last 6 months

Hi, in line chart, how do I display data for only the last 6 months? Cause' dimension limits only have the option of displaying first,largest and smallest values. Thanks.

• ###### Re: dimension limits display last 6 months

Sum({\$ < Year = {">=\$(Year(Today())-5)"}>} Sales)

• ###### Re: dimension limits display last 6 months

if it is just a simple dimension, then create a calculated dimension as follows:

if (Year >= Year(today())-5, Year)

Then check "Suppress when null"

Thanks,

Ram

• ###### Re: dimension limits display last 6 months

Hi Rachel,

Try this expression

=Sum({< YearDimensionName=, QuarterDimensionName=, MonthDimensionName =, DateDimensionName= {'>=\$(=MonthStart(Max(DateDimensionName), -5))<=\$(=Date(Max(DateDimensionName)))'}>} MeasureName)

Replace YearDimensionName, QuarterDimensionName, MonthDimensionName, DateDimensionName and MeasureName with your actual fields.

Hope this helps you.

Regards,

Jagan.

• ###### Re: dimension limits display last 6 months

Hi Jagan,

How can I do this in dimenssion level.

Regards

Anup

• ###### Re: dimension limits display last 6 months

Hi,

Try

In UI:

Or

Inscript:

if(
Date >= AddMonths(MonthStart(today()), -5) and Date <= monthstart(today()), 1, 0) as Flag6Month

RESIDENT Table;

And use flag as required

Regards

Neetha