Problem in Cal. Dimension

[#1]

Hi Guys

Why my following expression is not working ????

=ValueList($(If(aggr(Rank(Sum(Sales)),Product) <= 5,Product)))

If i am removing the $ sign still i am getting error. and if i am putting ' '  then no error but QV is not evaluating the condition(If(aggr(Rank(Sum(Sales)),Product) <= 5,Product)) rather considering it as a text.

Please Help

[er_mohit]

try rangesum function replacing sum

might be helpful.

[#3]

using this function

rangesum(above(sum(Sales)

[#4]

NOT WORKING