Results 1 to 3 of 3

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

  1. #1

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



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

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

  3. #3

    Thanks very much!!!!

    I really appreciate that


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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •