Hello I'm new to Crystal Reports and trying to decide if it will work for my office so I'm trying to learn everything by just using the program and skimming the user manual. I ran into a problem that I fell should be a easy solution but my little experience within the program I personally can't figure it out. Here is the issue( Below i will show a  an example) I have three rows of data each with a unique Area ID(It is from US Census data) for columns I have total population, High School Diploma, Some College(Less then one year), Some College(1 or more years), Associates Degree and Bachelor's degree. Each row has a number for each column for number of people in that area that fits into that equivalence.  What I need from the report is a add up each Column(which is easy with the summary tool) but then I need to add the sum of High school diploma, some college(<1 year), some college (>=1year) to get everyone with a high school diploma and also add associates and Bachelor's to get everyone with a associates or Bachelors degree. I then need to find the percent of the population for those two groups by taking that sum and diving by the population and multiplying by 100.

here is the example
what i have

       Total       High School, Some College,Some College,Associates, Bachelor's
ID,population, Diploma,     (<1 year),        (>=1year),     Degree        Degree

1   1000            500           70                      50              70              130

2   1100           550            80                      70               90             150

3  1300            700            50                      90               120           100

Grand sum
    3400           1750           200                    210              280            380


now what I need is a report that tells me from this table
a grandsum of all people with High School Diploma but No Degree so I need to add the grand sum of High School Diploma, and both Some College. Then take that sum and divide by the total population to find the percent I then also need a grandsum of people with a associates or Bachelors. Then need to take that sum and divide by the total population for the percent

This is what i Want to get to
                                                 Number of people    percent of population
Only High School Diploma                       ####                       ##%
Bachelors and Associates Degree             ####                       ##%

I could really use the help thanks for your help