Week start selection

[its_anandrjs]

Hi All,

I have urgent requirement that if i select the weekstart value in weekstart list box

it should display like when selection 8/8/2011

it should display this

8/7/2011

8/6/2011

8/5/2011

8/4/2011

8/3/2011

8/2/2011

8/1/2011

and sum the values on that days.

Regards

Anand

[its_anandrjs]

Hi BlackRocks,

Thanks very much but what does this code

Weekstart(Date+7)

it adds a 7 in dates.

Regards

Anand

[SunilChauhan]

hope this  helps

[#4]

Hi,

No it wont add anything to your dates, but just dynamically adds 7 to the date and creates week start to meet your requirement of week start selection which is differnet than the normal.

Cheers.

[christian77]

Hi:

When I have to refer to a last year or month, I do the next.

Set 2 vars:

CurrentWeek = max(week)

LastWeek = max(week) – 1

Then I use them in set analysis:

Sum({$<Week={‘$(CurrentWeek)’}>} Sales)

Sum({$<Week={‘$(LastWeek)’}>} Sales)

What do you want to do exactly, show a list or do calculations?

For only a view, use a list with an expression or create a graphic with a calculated dimension.

If(Week = $(LastWeek), week)