Pivot Table - Divide one column by another

  • Hello everyone,

    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.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!