Ranking highest amount based on sub-category and main-category

[hongen909]

Hi all,

I have the following sample dataset:

Source	Voucher Number	Amount
AP-001	1001	50
AP-001	1002	100
AP-001	1002	150
AP-002	2001	300
AP-002	2001	100
AP-002	2002	500
AP-002	2002	200
AP-003	3001	50
AP-003	3001	10
AP-003	3002	40
AP-003	3003	100
AP-003	3003	250

I would like to summarize the above by grouping and ranking the highest total amount based on "Voucher Number" then further group to "Source".

For example, I would like the result as below:

Source	Voucher Number	Amount
AP-002	2002	700
AP-003	3003	350
AP-001	1002	250

Thanks in advance!

[binuacs · Accepted solution]

@hongen909 One way of doing this

[hongen909]

Thank you very much!