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 | | | | |
