How to get Top 25 records

[sumanta1234]

How to get top 25 records in the straight table.

[tresB]

Have you tried Dimension Limits (tab) ?

[sumanta1234]

Used Fixed value 25 but did not work.

[tresB]

Could you share your sample app?

[pradosh_thakur]

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)

[pradosh_thakur]

Then off course 

Addons-> data handling-> uncheck include zero values

[jonathandienst]

>>Used Fixed value 25 but did not work.

Please be more specific if you want useful assistance.

[sumanta1234]

I have applied your expression but not get the proper result.

[pradosh_thakur]

If your customer code is unique you will get proper result. What is the difference , may be you can post a sample app to have a look and help you out.

[pradosh_thakur]

Try this

new expresion ------- >     If(Rowno(total) <26, your_expression,null()) 

supress zero under addons-> datahandling