Thread: Percent of Total for multiples locations and periods

I'm trying to create a chart that shows a percentage of the total for multiple locations and periods. For example:

I have 10 different kitchens I'm keeping track of (Kitchen 1 - 10) and for each of the 10 different kitchens I want to show the amount of dinners that have been served to date and from that total, the percentage of how many deserts were served out of those dinners to date.

Along with that metric for each of the kitchens, I want to show the amout of dinners served by week and from that total the percentage of how many deserts were served out of those dinners.

How can I do this within Excel 2007? Or is this even possible? Thanks in advance for any help.