Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Joliette, Quebec, Canada
    Posts
    290
    Thanks
    9
    Thanked 0 Times in 0 Posts

    % of colums with pivot table (2003)

    I have a pivot table : the lines are type of injury (accident or illness) the next levels of lines are sex and age group. The columns are year of events; the data is the count of occurrences for the type of injury, sex and age category. Up to there I am fine, but I need to add a column percentage that computes the percentage of the total of illness women (for all age groups) it is say 10 000, for each age group say 2000 for the over 60 should give me 20% and if the age group of 30 to 39 the number was 25 000 the corresponding percentage would be 25%. I tried to add the count of occurrences and selected % of column the for the year 2000 let us say it was 100 000 cases for accidents and illnesses, and the result of 2000 for illness and over 60 would be 2%. Bassicalle I want the each of the sub tables for type injury and sex to each add up to 100%.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: % of colums with pivot table (2003)

    Could you post a small sample workbook and explain what exactly you want to calculate in the sample workbook?

  3. #3
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Joliette, Quebec, Canada
    Posts
    290
    Thanks
    9
    Thanked 0 Times in 0 Posts

    Re: % of colums with pivot table (2003)

    here is the data
    Attached Files Attached Files

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: % of colums with pivot table (2003)

    Thanks. And what exactly do you want to accomplish? Please try to be specific.

    Added later: sorry, I had overlooked the tiny comment indicators.
    I don't think you can do that in a pivot table (but hopefully someone else will correct me), as far as I know you'll have to calculate those percentages some other way.

  5. #5
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Joliette, Quebec, Canada
    Posts
    290
    Thanks
    9
    Thanked 0 Times in 0 Posts

    Re: % of colums with pivot table (2003)

    thank for your help, i can also select each subtable and copy them to a new worksheet

Posting Permissions

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