Forum Discussion
Sorting defects based on the date they were found
Hi I need help finding a formula that will sort and add defects(Splay, Flash, Short shot, Burns, Sinks, and Other) based on the month they were found in from "Sheet 1" and bring the Qty over to the "...
Thanks it does look simpler but i have 2 question first one is can i take the defect quantity and the month quantity's and have them put into the chart page from the pivot chart and does it automatically update with new info. Thanks
TMan5757 The pivot table source can be made in such a way that it automatically expands when new data is added. If it can be put in what you call "the chart page" is difficult to judge. Not sure if you even would want to use that page, as it isn't really easy to maintain (at least, that how I think about it). My hope was that by showing you the pivot table, you would be triggered to rethink your approach to this report altogether.