Calculate the attendance based on a monthly basis in a Pivot Table
I need to calculate the percentage of attendees for each month by the total number of participants for the month.
(Total number of participants comprise of both "Attended" people and the "Did Not Attend" people).
Please refer the provided screenshot and the data set herewith.
For example, the respective percentage under month "December" for the Age Group "Age 0-19" should be 42.5% which is 17 / 17+5+15+3 (Attended number for the age group divided by the total number of participants for the selected month, which is "December".
Similarly, Percentage for the month "January" for the same group (Age 0-19) should be 21% ( 12/56).
I tried an expression as "=Num(Sum(Attended) / Sum(TOTAL <[Month]>Total_Attendance),'#,##0%')" to calculate the percentage (as per the calculated screen shot data) of attendance but does not give me the expected outcome.
Could someone please help me to derive the correct expression to calculate the correct percentage based on a monthly basis.