Storing multiple levels of aggregation is a good idea. Storing them in the same table is a bad idea. Each table should have a consistent "grain". One of the problems...