I have a Look with a simple pivot table: the rows are week numbers (Week 01, Week 02, etc to Week 12) and the Columns are years (2018, 2019, 2020). I want the data in the middle of the pivot to be a percentage: we run maths tuition sessions and so the percentage I want is %_attended_sessions = attended_sessions / all_booked_sessions. I can get attended_sessions and all_booked_sessions into the table and my desired percentage into the table.
What I can’t get is just the percentage (each year is different, so it is the percentage I want to compare). Likewise the visualisation plots both the sessions_attended and all_sessions as well as percentage.
Please can anyone help?
LinkedIn
Twitter
