Having an issue with my Pivot Table, wondering if someone can help me and show me the

[2low4snow]

For some reason or another I am having trouble with some of the data on my PV, probably because I haven't done one in about 5 years and forget.
I don't seem to have the required permissions to attach a file, so here is a link to my SS.

My objective is here is to have Maturity, Cpn and Rate in the Columns section to go across the Pivot table.
When I put maturity in there, I think Excel see's it as a number and not a date...I tried formatting the cells but
obviously I was doing something wrong here. The Rate also has some Alphanumeric values in it, so I am trying to
figure out how the Pivot table needs to read it correctly and bring it over from the data table.

Many thanks in advance for looking.

MTN_Pivot.xlsx

[Herbds7]

Excel 2010 PivotTable
Revised file.
Too many changes to list.
http://www.mediafire.com/view/8ul7lp...04_29_15a.xlsx

[2low4snow]

I really appreciate that


[QUOTE=Herbds7;18388]Excel 2010 PivotTable
Revised file.
Too many changes to list.