Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sgrahman
Starting Member
10 Posts |
 Posted - 2007-08-06 : 10:03:48
|
| I was trying to find out the percent of students by gender within each school and grade from the following table. I used a matrix reports and I have school and grade in the row cell and gender in the coulumn. In the data cell I have count of student. I have the count of male and female students in the matrix report but I could not calculate the percent. Does anyone know how to do percent in Matrix report?? Thanks! school id grade gender880 1018264 11 M920 1020324 12 F880 1021864 12 M920 1027596 12 M900 1027620 12 M900 1030596 12 F880 1041440 11 F900 1051152 12 F880 1052988 11 F880 1052992 12 F920 1062388 11 M |
|
|
sgrahman
Starting Member
10 Posts |
Posted - 2007-08-06 : 10:53:52
|
| The report would look like this after adding subtotal and percent:School Grade F % F M % M Total880 11 2 67% 1 33% 3 12 1 50% 1 50% 2 Total 3 60% 2 40% 5 |
 |
|
|
sgrahman
Starting Member
10 Posts |
Posted - 2007-08-06 : 12:02:36
|
| I was able to solve this problem myself. Hurrrah!!!!Thanks. |
|
|
|
cheeeeeetah
Starting Member
2 Posts |
Posted - 2007-08-10 : 06:25:17
|
quote:
Originally posted by sgrahman
I was able to solve this problem myself. Hurrrah!!!!Thanks.
please tell mee your soloution.beacause i have similar problemthanks bye |
|
|
|
|
|
|
Calculate Percent in Matrix Report