Newbie needs help with setting up pivot table

[PostMaloney]

Hi guys,

I would like to know the daily average of the rate sum per booking source (CI, TI, Internet, Website, ZI).
In the excel sheet below, you can find the total rate sum for each individual stay, and the rate per night (ARR).
Could anyone please help trying to calculate the total rate average for all CI bookings on each day.

Many thanks,

Post Maloney

[interested]

hi does the attached work for you?