Transpose Data

Hello All! I have a question on how can i attain the report below. As you can see i have two tables: an appointment table and a date dimension table. Working Day is a measure wherein it determines i...