• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Aging of Document

T

Thomas Kuriakose

Active Member
Respected Sirs,

We have a data which is executed on a weekly basis with Document numbers and their dates.

We need to find out the aging of the documents based on the report date and week by week

Can we get a summary in pivot as below attached sheet-

Thank you so much,

with regards,
thomas
 

Attachments

Hi Thomas,

Can you explain further the week by week part of your question? I'm having trouble understanding.upload_2016-3-23_13-31-55.png

For the row labels, I can understand that as "is the document age >365? greater than 180? greater than 90? etc". Is that correct?
 
Luke M said:
Hi Thomas,

Can you explain further the week by week part of your question? I'm having trouble understanding.View attachment 28900

For the row labels, I can understand that as "is the document age >365? greater than 180? greater than 90? etc". Is that correct?
Click to expand...


TK- do you want to break them out as purely greater than or as ranges, e.g. 0-30,31-90,91-180,181-365, >365 ...?
 
Here's my first iteration --- Like LM, I don't comprehend the Week by Week element ... But I think this will help you gather your thoughts

The Grouping Column in my table can be built in to the Calc for Age Range, but I tend to go step-by-step .... ;)
 

Attachments

Respected Luke Sir,

Thank you very much for the help on this.

The report is run on every Thursday of the week and hence we would like to see the week by week data to check whether there have been improvements in the aging data over the previous week. For this report the date entered is 23.03.2016 and this falls on week 13, the next report will be on 30.03.2016 which will be week 14.

When the report will be executed the date will be changed in E1 in data sheet and the count of the documents will move to Week 14 - I5 onwards.

Respected David Sir,

We would like both the combinations of ranges and greater than to see which values are reflecting the correct trend.

Thank you very much,

with regards,
thomas
 
Thomas Kuriakose said:
Respected Luke Sir,

Thank you very much for the help on this.

The report is run on every Thursday of the week and hence we would like to see the week by week data to check whether there have been improvements in the aging data over the previous week. For this report the date entered is 23.03.2016 and this falls on week 13, the next report will be on 30.03.2016 which will be week 14.

When the report will be executed the date will be changed in E1 in data sheet and the count of the documents will move to Week 14 - I5 onwards.

Respected David Sir,

We would like both the combinations of ranges and greater than to see which values are reflecting the correct trend.

Thank you very much,

with regards,
thomas
Click to expand...

If you're going to track the data weekly, you will need to a date to your current dataset - so that you count based on each week. The dual aging measures will also need to both calculated as the the Pivot Table grouping isn't flexible enough to adapt to your measures.
 
You must log in or register to reply here.
Back
Top