Set analysis

[#1]

Requirement-  yr  and month is present eg- 11/2013 on clicking this ... ..> show the sum of budget from Jan 2013 till nov 2013 should display...

Please let me know how to do it .

Thanks

Kamal

[jagan]

Hi,

Arrive a date field in script like this

LOAD

*,

MakeDate(Right(MonthFieldName, 4), Left(MonthFieldName, 2)) AS DateFieldName

FROM DataSource;

Now use this expression

=sum({<MonthFieldName=, YearFieldName=, DateFieldName={'>=$(=YearStart(Max(DateFieldName)))<=$(=Date(Max(DateFieldName)))'}>} MeasureName)

Note: MonthFieldName, YearFieldName, MeasureName with your actual field names.

Hope this helps you.

Regards,

jagan.

[#3]

thank you so much for you response Jagan this really helps me

[jagan]

Hi Kamal,

Please close this thread by clicking Correct Answer button to my post.  This helps others in knowing the answer for similar scenarios.

Regards,

jagan.