Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try rangesum function replacing sum
might be helpful.
using this function
rangesum(above(sum(Sales)
NOT WORKING