Multiple period selection

[tim_leijen]

Hi all,

I'm trying to create a graph which shows the YTD data and the YEAR TO GO (the Year to go would be the budget minus the YTD months) However I don't know how to create an expression which works separate from the period selection table...

[Or]

sum({<Period = >} YearToGoBudget)

Have a look at the help / online resources for set analysis for more information.

[jyothish8807]

Hi Tim,

Try this:

YTD: sum({<Date=, Date={'<=$(=date(max(date)))>=$(=date(Yearstart(max(Date))))'}>}Budget)

Year to Go: sum({<Date=, Year={'$(=Year(Max(Date)))'}>} Budget)

  - sum({<Date=, Date={'<=$(=date(max(date)))>=$(=date(Yearstart(max(Date))))'}>}Budget)

Br,

KC