Displaying more dimensions then expected.

[#1]

Hi techies,

i have an issue with dimension display

i have an expression to display only max 16 weeks but its displaying more then that the expression is

'rangesum(above(Sum ({<WeekID = {"<=$(=max(WeekID))>=$(=max(WeekID)-15)"}>}[Invoiced Qty in LB]),0,RowNo(total)))' which shuld show me only 16 weeks but its displaying 23 weeks. can some body help me with this issue, its really urgent.

[jonathandienst]

Hi

Try limiting the dimension to 16 weeks, use a calculated dimension like:

     =Aggr(Only({<WeekID = {"<=$(=max(WeekID))>=$(=max(WeekID)-15)"}>} WeekID), WeekID)

If you are using QV11 or higher, you could use dimension limits instead of a calculated dimension.

HTH

Jonathan

[#3]

Hi,

thanks for your reply but its not working

I am using QV11 and tried largest 16 dimension limits but its displaying largest in terms of qty values not on largest 16 weeks.

[jonathandienst]

Did you try First?

Did you try the calculated dimension?