Looking for Ageing Analysis for Forcasting

[#1]

Hi,

I have a Ticket with departure date and I would like to know the days prior to departure as mentioned below

Row Labels	120dpd	90dpd	60dpd	30dpd
2/29/2012 - 3/6/2012	62	13	59	11
3/7/2012 - 3/13/2012	88	34	13	20
3/14/2012 - 3/20/2012	63	37	18	13

Difficulties:

Last week DPD ( days prior to departure ) Values was in the 90days cell next week it will jump to 60days cell

Thx in Advance for the Help

[brenner_martina]

Hi,

I think the class-function can help you, look at the example.

Greetings from Munich

Martina

[#3]

Hi,

Thank you Martina for replay.

Actually the requirement is

Row Labels	120dpd	90dpd	60dpd	30dpd
2/29/2012 - 3/6/2012	62	13	59	11
3/7/2012 - 3/13/2012	88	34	13	20
3/14/2012 - 3/20/2012	63	37	18	13

Look at the Highlighted 13 tickets will be in 90dpd for the first week 60dpd for the second week and 30dpd for third week.

Data should be represented in this manner

As per the Analysist he assumes wat is the Age of the Ticket and plans for the month.