Limit dimension by date value

[#1]

Hi, I have an input box where the user inputs a date in  MM/YYYY format.  I would like to put a line of set analysis in my dimension limit my graph to the input box date minus 12 months.  Any suggestions?  thanks, Jim

[#2]

Hi Michael, can I send a question on a QV issue?

Jim Francisco

M&T Bank Treasury - ALM group

Understanding What's Important

(716)842-5684

[#3]

Michael, the if statement in my dimension expression box works great to limit my dimension periods to 18 mths.

=Date(If(PeriodDate > MonthStart(Today().-18,PeriodDate, Null()),'MM/YYYY')

Now my chart shows the dates as numbers.  Can I switch them back to the MM/YYYY format?   The dates are set in the load statement to load as MM/YYYY.   Thanks, Jim

[#4]

Hi Krishnamoorthy, I've been using the dimension expression you provided in my Pivot Table.

=Date(If(PeriodDate > MonthsStart(Today)-18),PeriodDate,Null()),'MM/YYYY')

The only problem is that is returns a collumn with a Null date, and sums up the data that doesn't match the date criteria.

ie

3/2012     4/2012      5/2012     6/2012     7/2012     -

$1000       $2000     $3000     $4000          $5000     $6000

[#5]

got it. Dimension, Settings, "supress when value is null"