
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to Rank Data not by month year.
My Dataset like below.
Month Cust_ID Balance
202101 a1 100
202102 a1 200
202203 a1 300
202203 a2 400
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
4 202101 a1 100
3 202102 a1 200
2 202203 a1 300
1 202203 a2 400
- Subscribe by Topic:
-
Developers
-
dimension
-
expression
-
Script
-
Set Analysis
-
Visualization
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Rank(Total Cust_ID) solve my problem

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
In Rank field use: AGGR(RANK(SUM(Balance)), Cust_ID,Month)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Onkar10 ,
I try this expression before. However, this is like group by ID, Month.
The result will like this.
Rank Month Cust_ID Balance
4 202101 a1 100
3 202102 a1 200
1 20203 a1 300
1 20204 a2 400
Let my reclarify i want the result like below
Rank Month Cust_ID Balance
4 202101 a1 100
3 202102 a1 200
2 202203 a1 300
1 202204 a2 400

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
= AGGR(RANK(SUM(Balance)), Month)
This should give you result you want.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Onkar10, would you try the data like 202203 a2 400. I dont know why my result rank still not accurate.
I think maybe Cust_ID appear more than one. But after month filter Cust_ID will be distinct.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Same result with :202203 a2 400

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Rank(Total Cust_ID) solve my problem
