I'm fairly new to pivot tables and am not finding them as useful as I thought they would be.
The current pivot table I'm working on has a list of programs down the rows, with the years across the columns separated by application status (Awarded, Refused, etc.) and a total count for each year. What I need to do is show the % of total applications for each year, for each program that are awarded.
In other words I simply need to do Awarded/Total for each year. However in calculations this is not an option, as it will only allow me to select Application Status, and not a particular status such as awarded. Is there any way around this, or an easier method of doing this?
Thanks in advance, I realize this may be a stupid question but I'm sure you're well used to those by now.