Forum Discussion
RANKing
Date Fund Rank 01/01/2021 A 1 01/01/2021 A 1 03/01/2021 A 2 04/01/2021 B 1 05/01/2021 B 2 05/01/2021 B 2 06/01/2021 C 1 07/01/2021 C 2 08/01/2021 C 3...
Anonymous
NOTE: Need to add the index to differentiate the first 2 rows here
RANK=RANKX(fILTER(Table1,[Category]=EARLIER([Category])),[Date],,DESC,dENSE)
Ritesh Bisht
Anonymous
NOTE: Need to add the index to differentiate the first 2 rows here
RANK=RANKX(fILTER(Table1,[Category]=EARLIER([Category])),[Date],,DESC,dENSE)
Ritesh Bisht