This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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
@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
.png "Employee"){kind=icon}
