I am trying to use Window_sum function for weekly data and need to re-state the total values for every Quarter. then below function provides the running total for whole year RUNNING_SUM(sum([sales])) . Any help on this is much appreciated. Thanks.
- Thangavel
To add more we are trying to use Parameter control and have the data vary based on selection like YTD, QTD. So trying to do the running total calculation in the calc with Quater window & yearly window period.
Thanks.
Thangavel