I have a sales table that contains the records for all sales data and am having trouble figuring out the best way to harvest it for summations for reports, etc. My difficulty comes from the table being arranged with additional columns added for each month's sales as opposed to a "Sales" and "Month" column only. This allows for far less records, however I am not used to working with this type of table.
How I go about this is crucial as it acts as my Fact Table which my database will be designed around.
Should I just create queries to select only sales from one month and use the results of those 12 queries from there? There must be a more efficient way to do this.