Trying to create time series database pivot table

Hello,

I want to create a time-series database in a pivot table using multiple data sources (csv files, web pages, etc). Right now I have several connections in a data model with the relationship between them being the date. But when I create the pivot table it doesn't come out as I want it no matter how I play around with the field list. Enclosed I have a sample (Money Market - example) where I have two sheets, one called 'pivot table' with the pivot table from the data model and another called 'goal' which is what I want it to look like.

Any help would be appreciated.

Thanks
Matt