Greetings all,

I have the following pivot table;

<tbody>

</tbody>* Outside of pivot table with =GetPivotData

My first goal is I would like to calculate the % enrolled from within the pivot table - I feel like it should be simple to make these calculations, but this probably shows my unfamiliarity with Pivot Tables, because it is not simple. I would like this data within the pivot table as I need the data to be dynamic. The end goal is to view this information in a chart;

What I really want is to have a data point that shows the percentage enrolled above each series. I achieved this chart by increasing the series overlap to 100% on a clustered column chart. I feel like there may be a better way to do this, but this is all I've been able to come up with so far and I'm stuck. I'm using Excel 2013. Thanks in advance for your assistance.

Thank you,

Anthony

I have the following pivot table;

Row Lables | Count of Eligible | Count of Enrolled | Manual Calculation (Enrolled/Eligible)* | |

a | 6 | 4 | 66% | |

b | 4 | 1 | 25% | |

d | 3 | 2 | 66% | |

Grand Total | 13 | 7 |

<tbody>

</tbody>

My first goal is I would like to calculate the % enrolled from within the pivot table - I feel like it should be simple to make these calculations, but this probably shows my unfamiliarity with Pivot Tables, because it is not simple. I would like this data within the pivot table as I need the data to be dynamic. The end goal is to view this information in a chart;

What I really want is to have a data point that shows the percentage enrolled above each series. I achieved this chart by increasing the series overlap to 100% on a clustered column chart. I feel like there may be a better way to do this, but this is all I've been able to come up with so far and I'm stuck. I'm using Excel 2013. Thanks in advance for your assistance.

Thank you,

Anthony

Last edited: