Forum Discussion
Defect aging pivot chart
Need help in reflecting days in <10 days, < 20 days, etc. in Pivot chart (see attached)? Ultimately, the desired output is the Active Defect Age Analysis chart included in attachment. Thanks
See the attached version. I added a helper column to the source data, and changed the status to be able to sort it.
6 Replies
The solution might involve some creative grouping of the 'age of defect' in the row labels. It's difficult to get the desired chart because the data is not all there and there are no records for "critical", for example.
Please see updated attachment. Thanks
Can't do anything with the workbook since the source data are not included.
Please see updated attachment. Thanks
See the attached version. I added a helper column to the source data, and changed the status to be able to sort it.
