It would certainly be more flexible to start with the original data.
Tableau can combine measures using what's called Measure Names/Measure Values. I've attached a sample using your excel data that shows the population pyramid for 02-03 on one sheet and the totals for 03-04 on another sheet.
The population pyramid is built using a calculation that changes the female numbers to negative values.
Unfortunately, there's only one Measure Names/Measure Values per sheet, so it's not possible to combine the 02-03 numbers into one measure and the 03-04 numbers into another measure on the same sheet.
The easiest way to build these views is
1. drag College Name to Rows
2. drag Female Applicants to Columns
3. drag Male Applicants onto the X-axis (female applicants)
4. Move MeasureNames from the Rows shelf to the Color shelf
Combined Measures.twbx 3.5 KB
Excellent answer! That's solved much of the problem.
Do you have any plans to allow more than one Measure Name/Value per sheet?
Thanks for the answer