Data Analysis actual vs forecast

[Nadimtukin]

Hi,

I am working on one excel work sheet were i need please help on..i have created dummy template attached here.

I have data for each day for actual orders and forecast, i have then calculated percentage difference of them. now i want to put summaries and see if there is any trend were particular day of the week order is lower or higher then forecast.

I am not sure if this can be done through any formula or has to be through pivot table.

Hope someone could guide me here.

thanks

Nadim