Rank within category and within month

[Antmkjr]

DateOfReceipt	Name	Amount
1/19/2022	A	80
1/15/2022	A	100
1/14/2022	B	60
2/14/2022	C	20
2/7/2022	C	40
2/11/2022	A	50
3/14/2022	B	30
3/18/2022	A	20

 In the above sample data, i need to create a pbi report, which shows the ranking of each categories in each month.

So Rank for Month 2 , will show for Category A = 2, Category C =1.

For month = 1, Rank for Category A = 1, Category B =2

[daXtreme · Accepted solution]

Please find a file attached.