How to Rank Data not by month year.

[eddywong71]

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

[eddywong71]

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