Report/KPI generation

We'd like a function that allows us to pull weekly reports on things such as money made on specific decoration processes across a working week, two weeks, a month, etc. Total sales reports are good and all, but I'd like to see how well each department is performing without having to calculate it all myself manually.