It may make sense to keep different levels of aggregation in different tables at the sametime, and use the most suitable table for a particular report.
