Forum Discussion
Solved
Calculating % Yield measure
Hello, I am trying to make a table with the Yield rate(which is total enrolled divided by total applied) by year. Is there a way to do it? A formula? My Data looks like this:
Create a Measure (call it anything that works for you). Since you want % at the ROW level, the formula doesn't have to take into account any filtering or grouping...
Measure = SUM(Table1[Admitted]) / SUM(Table1[Applied])
Raw Data I entered based on your screen shot & Matrix with Rows = R&E, Columns = Year, & Values = your measure
I was hoping for something like this:
Create a Measure (call it anything that works for you). Since you want % at the ROW level, the formula doesn't have to take into account any filtering or grouping...
Measure = SUM(Table1[Admitted]) / SUM(Table1[Applied])
Raw Data I entered based on your screen shot & Matrix with Rows = R&E, Columns = Year, & Values = your measure