My office has an online complaint form which stores all the statistics I
need to come up with the year end report. I import the stats from a SQL
server into an Excel file. And I need to be able to sort out for example,
how many code 1.3.3 there are and what college had the problem and what
levels (freshman, faculty, masters) they were. I've always used pivot
tables in excel to do this and make all my charts. But now we've added 2
more columns of codes and 2 more columns of problem sites (because a student
might have more than one problem in more than one site) to the spreadsheet.
Well I can't figure out how to first off sort out the 1.3.3 in the 3 columns
and then find the college & level.for all of them. I know this sounds
confusing (at least to me it does) *s*. When I do a pivot table putting the
level and site on the column side and the code 1, code 2, & code 3 on the
top with count of code 1, 2, 3, etc. in the middle...I then deselect
everything except 1.3.3 in each of the code columns..the count goes blank.
If I just do code 1 it works fine. There has to be an option out there that
I don't know about so any help would be appreciated. Thanks!