Thanks!
Really, I think I was making it more difficult than I needed to. Eventually, I just through my column for different subgroups into the column labels area and was easily able to calculate the values as a percent of the grand total.
Faseeh,
Thank you for your response. Here is a pivot table I created that looks similar to what I am working with. Columns D, F, H, and J are the columns with values I want to turn into percents of the grand total of students - Cell B20 - 20 students. Ultimately I want to tell the percent each...
Hi,
I am trying to figure graduation rates for a school district. I need to find a fast, efficient, and safe way to calculate the percent of specific subgroups percent who graduated and did not based off a grand total.
Let me show you values from a hypothetical pivot table I am working with...