I have one year data(Fields are Date,Sales,Item,Branch)...i have to generate all dates between min(Date) and max(Date)..then i have to find cumulative sales for each Date(Order by Date)...
i Tried this.. but it took 2 hours to Generate cumulative for one month data...is there any Solution to reduce my loading time
Output should be like this
If you want only date keep the date part only . you can delete the others .The code i have taken from Creating A Master Calendar Don't forget to do full accumulation in the expression tab. Which is the main reason behind the accumulation.