set analysis

[#1]

hi,

I have a barchart that has the dimension year. And I make a seleciton on year and month. for example i select the year 2010, 2011 and 2012 and the month Aug and Sep. ok...so far so good. In the year 2012 I only have data to today's date (example: 10.09.2012). I am comparing in the bar chart my sales and I would like to compare it like this:

2010: 01.08.2010-10.09.2010

2010: 01.08.2011-10.09.2011

2012: 01.08.2012-10.09.2012

but for now 2010 and 2011 sales are shown to the end of september. does anyone have an idea how to solve this problem??

regards,

MT

[john_duffy]

Hi Miguel.

I know this is an old discussion, however, I have recently used your solution to use InYearToDate in a set analysis expression.

The solution works great.  I have one question regarding the syntax.  This funciton returns a true or false value.  What is the reason for having 'Date =' before the {"=InYearToDate.....?

Thanks for you help.

John.

[sandeeps_hyd]

Hi,

Thank you for earlier reply.

I'm trying to put 1 as identifier, but the expressions respects the user selections.

='YTD '&Num(Sum({1<[Code]={'FAIL','WARN'},

DateField = {"=InYearToDate(DATE, Today(), 0)"}

>}

Measure), '#,##0')

How to make my value intact?

Thanks.