How to Rank Data not by month year.

eddywong71 — Wed, 15 Mar 2023 04:39:56 GMT

My Dataset like below.

Month Cust_ID Balance

202101 a1 100

202102 a1 200

20203 a1 300

I am using AGGR(RANK(SUM{$} Balance)), Cust_ID). The expression is work fine when Month selected.

However, when user don't select any month. The same CUST_ID sometime rank are missing. I want the table include all month is rank by the balance.So That result like below

Rank Month Cust_ID Balance

3 202101 a1 100

2 202102 a1 200

1 20203 a1 300

topic How to Rank Data not by month year. in App Development

How to Rank Data not by month year.