Pivot Table

[Agape]

Hello,
I have a spreadsheet with 380,000+ rows.
Data is as follows:
Date Amount Country Region
2-Jan-20 800,000.00 GB NW
2-Jan-20 50,000.00 US W
2-Jan-20 30,118.79 AU NE
2-Jan-20 600,000.00 IS N
2-Jan-20 133,180.74 JP NE
2-Jan-20 35,983.82 CA N
2-Jan-20 1,935,722.22 CH E
2-Jan-20 26,700.00 HK E
2-Jan-20 4,125,000.00 GR SE

How to do a Pivot Table or a Macro to break this data out by tier (>= 5000 - <=10,000, - <=25,000 )
Please see attached image.

Any help is highly appreciated.
Thank you!

[HansV]

The easiest solution is to create a helper column in the source data that uses nested IFs or SWITCH to return the tier, and to use that in the Pivot table.

[Agape]

Thank you!