Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jun 2003
    Thanked 0 Times in 0 Posts

    Pivot Tables (Excel 2000)

    In this excel file under the i have two columns

    Industry SIC code and Total

    By using the pivotable feature i want to be able to seperate it out by 1000's ( SIC code) with the average next to it

    so it would say

    1000 avg of the 1000's
    2000 avg of the 2000's

    all the way down to 9000

    i am not sure how to do with with the pivotable? help?!?

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Pittsburgh, Pennsylvania, USA
    Thanked 342 Times in 335 Posts

    Re: Pivot Tables (Excel 2000)

    Easiset way is to go the original dataset and add a column that calculates based on the SIC value (If SIC is in column starting in C2:
    and copy it down the column
    (You can copy/ paste special - values to get rid of the formulas if desired)
    This will give you the thousands. Then uses this field in the pivot table.


Posting Permissions

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