Set Analysis Issue

[vipin_mishra479]

Hi All,

i have week wise data like this

Week	Sales
1	6,317
2	9,955
3	10,520
4	9,988
5	7,714

and my current week is 3

and want to show this in my chart

week                                Sales

2	9,955
3	10,520
4	9,988

1 past week and 1 future week of my current week.

[ashfaq_haseeb]

Hi,

Take week as your dimension.

write below expression.

=sum({<Week={'>=$(=week(today())-1)<=$(=week(today())+1)'}>} Sales)

Regards

ASHFAQ

[sasikanth]

HI

try some thing like this

=sum({<week-field>={'>=$(=Week(Month(today()))-1)<=$(=Week(Month(today()))+1)'}>}sales)

[#4]

Considering it is always for 1 month!

Create a variable v1 (To get current week no of the month):

=Ceil(day(Today())/7)

In chart Dim: Week

Exp :

sum({<Week={$(v1),$(=$(v1)+1),$(=$(v1)-1)}>}Sales)

Regards,

Prabhu