Need a pivot table to show rolling history

I have 1 year of data showing 42 different supplier defects. I need a pivlot table that I can update easily each morning to show the top 20 suppliers each day that have the most defects.
or Is there a better way to update charts daily to show a rolling 30?


The dates change daily Code Name 27-Jul 29-Jul 30-Jul 31-Jul 1-Aug 2-Aug 5-Aug 6-Aug 7-Aug 8-Aug Totals
1001 supplier 1 1 1 0 1 1 0 3 2 2 0 11
1002 supplier 2 1 0 0 2 1 1 0 0 0 1 6
1003 supplier 3 0 0 0 1 1 0 0 1 0 2 5
1004 supplier 4 2 0 0 0 0 0 1 0 0 1 4
1005 supplier 5 0 0 0 0 0 0 3 0 0 0 3
1006 supplier 6 1 0 0 0 0 1 1 0 0 0 3
1007 supplier 7 0 0 0 0 0 0 2 0 0 0 2
1008 supplier 8 0 0 0 0 1 1 0 0 0 0 2
1009 supplier 9 1 1 0 0 0 0 0 0 0 0 2
1010 supplier 10 0 0 0 2 0 0 0 0 0 0 2
1011 supplier 11 0 0 0 0 0 0 0 0 2 0 2
1012 supplier 12 1 0 0 0 0 0 1 0 0 0 2
1013 supplier 13 1 0 0 0 0 0 0 0 0 0 1
1014 supplier 14 0 0 0 0 0 0 1 0 0 0 1
1015 supplier 15 0 0 0 0 0 0 0 0 0 1 1
1016 supplier 16 1 0 0 0 0 0 0 0 0 0 1
1017 supplier 17 0 1 0 0 0 0 0 0 0 0 1
1018 supplier 18 0 0 0 0 0 0 1 0 0 0 1
1019 supplier 19 0 0 0 0 1 0 0 0 0 0 1
1020 supplier 20 0 0 0 1 0 0 0 0 0 0 1