Account Recieveable Aging

[israrkhan]

Hi Community,

i have to create a chart, to show aging for Account Recieveable..

i have a table data like below:

document ID is Unique, And creation date is off course one date for one document, but the one document will have many posting dates, when he got Amount for specific document, he will create new entry for that document. you can see document one has 3 entries, and three posting dates...

..user want to select the posting date and want to see the aging, i want to calculate through calculated dimension..

if user choose 02/01/2015 , second posting date of document id 1..i have to create aging from that date...

your comments, will be highly appreciated...

Header 1	Header 2	Header 3	Header 4	Header 5
DocID	CreationDate	PostingDate	Amount	other fields..
1	01/01/2015	02/01/2015	1000
1	01/01/2015	05/01/2015	200
1	01/01/2015	15/01/2015	400
2	25/02/2014	26/02/2014	600
2	25/02/2014	28/02/2014	100
3