Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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.
Did you try First?
Did you try the calculated dimension?