Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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
Hi Sreevidya
have a look at this
best regards
chris