How to get continuous fiscalweeks?

[#1]

Hi,

I have dimensions and exression as below in bar chart

Dimension1: =IF(FiscalWeekSerial>=$(curFiscalWeekSeq)-4,FiscalWeek)

Dimension2: Staff

Expression: COUNT({<DateDue={'>$(=Today())'}>}DISTINCT(StudentID))

So, this will show the data as weeks on horizotal axes. s, it will show weeks as 31,32,33,34. Now we are under 34 fiscal week.

My user wants to see starting only from currentfiscalweek and continuing. i,e

34,35,36,37. Is that possible. I changed the dimension as below

IF(FiscalWeekSerial>$(curFiscalWeekSeq)-1,FiscalWeek)

and it is showing only week 34. But I need to show 34,35,36,37.

Is it possible? if so can anyone suggest me please.

Thanks.

[#2]

How can I display the next following weeks
?

[MK_QSL]

Dear Amelia,

If you want to show data for Previous 4 weeks starting from current week... you can use something like below...

SUM({<Week = {'<=$(=Week(Today())) > $(=Week(Today())-4) '}>}Sales)

If you want to show data for Next 4 weeks starting from current week... you can use something like below...

SUM({<Week = {'>=$(=Week(Today())) < $(=Week(Today())-4) '}>}Sales)

[#4]

Thanks. I would need to show the weeks display on the horizotal axes. Is it possible. Can you please change my exression please.

[#5]

I tried many ways but no luck Please any solution?

[MK_QSL]

Use dimension as Week

Tick Suppress When Value is Null in Dimension Tab

and use my given expressions.

[#7]

Thanks. I can not use SUM. I don't have issue with expression . Only the issue is with dimension. Is there any change do I need to make. Now I have another dimensin also.

Dim1:=IF(FiscalWeekSerial>=$(curFiscalWeekSeq)-4,FiscalWeek)

Dim2: Staff

Dim3: Department.

Actually I have to show how many students are in progress(overdue) with the weeks based on DateDue

[#8]

Please any help as this is very very urgent to me