how to get next immediate available value

[#1]

for example if i have dates as

1/10/2013,

4/10/2013,

5/10/2013

when i select 4/10/2013 I want 5/10/2013 related measures, and when i select 1/10/2013 i need measures (like sum sales) of 4/10/2013.

attached is a example file, thanks in advance,

[swuehl]

You can use something like this to get the next date according your selection:

='Next date: ' & date( min({<Date = {">$(=date(max(Date)))"}>}Date))

So you can create a variable vNext

=date( min({<Date = {">$(=date(max(Date)))"}>}Date))

and then use this variable in your next date aggregations, like

=sum({<Date = {'$(vNext)'}>} Value)

edit: added sample application

[#3 · Accepted solution]

Hi Sreevidya

have a look at this

best regards

chris