Using ROLLUP command, generate a monthly sub_total, yearly sub_total and grand total of each distinct product. Display Product descriptions

 

Product Dimension Product Key Product ID Product Description Product Code Brand name List Price Min Price Price Start Date Price End Date Current Rag Time Dimension Day Key Actual Date Day of month Month Quarter Year Sales Fact OrderDate Key(K) Product Key(FK) Customer Key FK Employee Key FK) Sales Dollar Amount Quantity Customer Dimension Customer Key Customelo Name Address City State Zip code Area code Phone number Credit Im comments Employee Dimension Employee Key Employee First name Middle initial Last name Sex Manager jd Hire date Salary Commission Job code dob