Dear forum, 

I am tracking how projects evolves, so I am gathering templates that always gets updated, in a single folder.

For ex: 

SiteA ProjectA 100113 ; SiteA ProjectA 011214 (mmddyy style)

SiteE ProjectB 010115 ; SiteE ProjectB 011215

SiteF ProjectB 020115

SiteF ProjectA 020115

I am trying to present in my charts only the sum of the latest file in each project & site (as it contains the latest data).

I want to display it in a pivot table and chart, like:

Year

       Project

                 Material Group

                                         Item

Any thoughts? 

I assume it is done with Calculate & filters, but no idea