topic Re: Ranking not work correctly in App Development

Ranking not work correctly

yyw — Mon, 17 Nov 2025 14:43:07 GMT

I am building a straight table to show top 10 orders, and also includes their information (such as product, customer).

I've tried these 2 methods but both of them did not get the correct top orders.

1. Click the order_number and limit to top 10.

2. Use Ranking expression.

The formula I used:

=AGGR(

RANK(

Sum(

BUSINESS={'A', 'C', 'D'},

YEAR={$(=YEAR(TODAY()))},

MTD_FLAG={'Y'}

ORDER_AMOUNT

)

,0,1),

BUSINESS,

ORDER_NUMBER

)

Re: Ranking not work correctly

Daniel_Castella — Mon, 17 Nov 2025 15:38:19 GMT

Hi @yyw

The first one should always work if the limitation is being done on the correct calculation. For the second one, I would need to see the raw data to reproduce it. Could you, please, attach it or the app with the object if possible?

Kind Regards

Daniel

Re: Ranking not work correctly

Vegar — Tue, 18 Nov 2025 06:08:06 GMT

It is a bit hard to troubleshoot without knowing more about the data and your selections.

What is MTD orders? Is it an expression or a recalculated dimension value? How is that calculation done?

I notice this set modifier:

YEAR={$(=YEAR(TODAY()))}, MTD_FLAG={'Y'}

The screenshot reveal nothing about those values in your selections. Could it be that the "faulty" blank doesn't meet the correct YEAR and MTD_FLAG criteria?

Re: Ranking not work correctly

Chanty4u — Wed, 19 Nov 2025 05:35:10 GMT

Use this in calculated dimension

=If(

Aggr(

Rank(

Sum({<BUSINESS={'A','C','D'}, YEAR={$(=Year(Today()))}, MTD_FLAG={'Y'}>} ORDER_AMOUNT)

,0,1),

ORDER_NUMBER

) <= 10,

ORDER_N

UMBER

)