Can anyone assist further with this enquiry?

I have two dimensions: Customer and Period


I have one Measure: Debt


I need to create the following:




Here is a snippet from the table:

Name Debt Date
Client 1 500 05/03/04
Client 3 1000 07/06/04
Client 2 100 01/01/04


So I would have the following report:


Name Debt >30 Days >60 Days >90 Days
Client 1
500
Client 2
100
Client 3 1000


Can anyone assist?