Have no idea about a purpose, anyway ...
Please find the attached.
The trick is in using nested LOOKUP() Table Calcs.
They are [Amount (inner)] and [Amount (outer)].
The former is Compute using [Bucket], the latter is along [Date].
Please take a look at the Addressing & Partitioning of these TC on a view.
Hope it could help.
Thank you Yuriy! This actually worked perfectly.
Guillermo, you're welcome.