Thanks so much for your responses, and sorry if I haven't provided enough context.

A data warehouse already exists for reporting throughout the sales department. We've got 8 or...

Sorry, I was going for brevity and probably needed to add more context.

Ultimately, the report will need to display the following:

My main concern is table size on the...