Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to get top 25 records in the straight table.
Used Fixed value 25 but did not work.
what if you change your expression to below
Let's say your expression is sum(Sales)
you change it to
Sum(Sales) * avg({<[Customer Code]={"=rowno(total) <26"}>}1)
Then off course
Addons-> data handling-> uncheck include zero values
>>Used Fixed value 25 but did not work.
Please be more specific if you want useful assistance.
I have applied your expression but not get the proper result.
Try this
new expresion ------- > If(Rowno(total) <26, your_expression,null())
supress zero under addons-> datahandling