Calculating past period sales

[#1]

Hi, all,

Im having some situation here:

I need to calculate end of months aging data:

For EoM March 2012 period, I use sales data from Sept 2011 to Feb 2012.

I should count all sales happened from that period, Sept 2011 to Sept 2012 as A.

Then i should count all sales which had overdue more than 30 days from the same period as B.

then I apply this formula: A/B.

Problem here, the aging data is running data.

If someone can help, please gimme sample data.

Or if someine encounter the same business process, please tell me.

[Anonymous]

Hi

     Hope the attached file will be helpful for your requirement

Regards

Ashok

[#3]

will read, and will update it as soon as i've checked

thanks anyway

[#4]

ashok, just reviewed urs, seems like not answering my question yet

Raw data:

Month | Value

Jun 2011 | 5

Jul 2011 | 2

Aug 2011 | 3

Sep 2011 | 4

Oct 2011 | 5

Nov 2011 | 1

Dec 2011 | 9

Jan 2012 | 7

Feb 2012 | 1

Mar 2012 | 1

Expected result:

Periode | Value

..

Jan 2012 | 24 (Jul 2011 - Dec 2011)

Feb 2012 | 29 ( Aug 2011 - Jan 2012 )

Mar 2012 |  27 (Sep 2011 - Feb 2012)

..

[Anonymous]

HI

     When i look up your expected result period and Value you just want the previous sex month value based on the\

month right

Regards

Ashok

[Anonymous]

Hi

     It seems you want the value for the previous six month based on the current month right

Regards

Ashok

[#7]

a bit right,

should be:

the value for the previous six month based on the "periode" month

so, i need data from some periode, example:

Periode | Data From

Dec 2011 | Jun 2011 - Nov 2011

Jan 2012 | Jul 2011 - Dec 2011

Feb 2012 | Aug 2011 - Jan 2012

Mar 2012 | Sep 2011 - Feb 2012

Regards,

David Sugito

Business Intelligence Developer

[#8 · Accepted solution]

I have solved this, by doing some manipulation on the data.

This was used to calculated FID (First Installment Default) in Finance Company.

If anyone has encoutered this, dont hesitate to contact me.