Query Table for MTD, QTD, YTD sales
I have a table sales_history with columns Region, Group, Invoice Date, Extended Price. I’d like to have current MTD, QTD, YTD sales grouped by Region then by Group. Appreciate someones assistance with a query.
|
Region East |
MTD Sales |
QTD Sales |
YTD Sales |
|
Group 1 |
|
|
|
|
Group 2 |
|
|
|
|
Region Central |
|
|
|
|
Group 1 |
|
|
|
|
Group 2 |
|
|
|
|
Region West |
|
|
|
|
Group 1 |
|
|
|
|
Group 2 |
|
|
|
|
Region International |
|
|
|
|
Group 1 |
|
|
|
|
Group 2 |
|
|
|