I'm building a sales database with 10 columns containing data on date, deal/no deal, client, product, size, currency, type etc. I'd like to compile some summary statistics, but I'm limited to excel 2007 and can't figure out any good options.

I'd like to be able to return these statistics (including custom ones based on the data) in a dashboard, but then I want to be able to filter them by custom date ranges (ytd, mtd, wtd) and also ranks of client in any given time period by size of deal. And others.

I've been playing around with pivot tables for a few days but it seems limited in it's ability to deal with those custom statistics. Also if I try get it to filter the dash by a custom date range I imagine it would freeze up excel for a while since it will have to change the dates manually for 10 or more pivot tables from the same data set.

I'd be willing to hire a freelancer for this, but would like to get some direction on how to build this project.