Post reply

Help w/ Pivot Table

  • February 21, 2006 at 12:56 pm

    #167760

    Hi everyone, I need help creating this pivot table asap!  Any assistance is much appreciated...

     

    Here is the data I have currently in an excel spreadsheet:

     

    Jan

    Feb

    Mar

    Apr

    May

    Jun

    Jul

    Aug

    Sep

    Oct

    Nov

    Dec

    Jan

    13

    12

    11

    10

    9

    8

    7

    6

    5

    4

    3

    2

    Feb

    2

    13

    12

    11

    10

    9

    8

    7

    6

    5

    4

    3

    Mar

    3

    2

    13

    12

    11

    10

    9

    8

    7

    6

    5

    4

    Apr

    4

    3

    2

    13

    12

    11

    10

    9

    8

    7

    6

    5

    May

    5

    4

    3

    2

    13

    12

    11

    10

    9

    8

    7

    6

    Jun

    6

    5

    4

    3

    2

    13

    12

    11

    10

    9

    8

    7

    Jul

    7

    6

    5

    4

    3

    2

    13

    12

    11

    10

    9

    8

    Aug

    8

    7

    6

    5

    4

    3

    2

    13

    12

    11

    10

    9

    Sep

    9

    8

    7

    6

    5

    4

    3

    2

    13

    12

    11

    10

    Oct

    10

    9

    8

    7

    6

    5

    4

    3

    2

    13

    12

    11

    Nov

    11

    10

    9

    8

    7

    6

    5

    4

    3

    2

    13

    12

    Dec

    12

    11

    10

    9

    8

    7

    6

    5

    4

    3

    2

    13

    I need to be able to return back the numbers in the columns.

     

    1. So the first row represents 1st Payment Due month
    2. And (top) Column represents Tax Bill month due in:

    I need to return the value in the column...How can I represent this?  This data is not currently stored in our dB...do I create a temp table storing the months?  What is my first step?

    Thanks in Advance!

     

     


    Aurora

  • February 21, 2006 at 3:09 pm

    #622470

    If you already have this table in the Excel spreadsheet, just import it in SQL Server using DTS Import Wizard specifying Excel file as a source and a new table in your database as  destination.

    Let us know if you need explanations on how to do that.

    Regards,Yelena Varsha

  • February 21, 2006 at 3:33 pm

    #622473

    Okay I have imported the table let me make sure it is something my developers can use...Thank you for your help and I'll keep you posted...

     

    Christine


    Aurora

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply