MV is the only way to do rolling sum.You can find a work around to do something similar but design it without MV in the following video:https://www.youtube.com/watch?v=8Cpr9GnGR2s&t=1shttps://www.youtube.com/watch?v=wmpgfXQr9Ac 

Hi @MT10 Can you review this video to use LEFT or RIGHT incorta function:https://www.youtube.com/watch?v=LlLPQFWvg2k

@msinha8 have you tried using running total for a measure?You will need to do that using Resultset.1. Create resultset with aggregated table2. Add company and first date of the month in dimension3. Add sales column in measure4. Enable Running total f...

@nikhil_cr Sample SQL to do this using MV:SELECT explode(sequence(orderdate, shipdate, interval 1 day)) as date, Total_Sales FROM order_ship_date_query_resultCheckout this video as well:https://youtu.be/u0GrrnK2ZHA