This content has been marked as final. Show 2 replies
I am trying to understand window calculations. Here, what I want is to calculate the sum of sales for particular partition i.e. from Index 1 to index 5. Please refer screenshot.
I am unable to understand the formula for Window_Sum(Expression, [Start, end])
Start and end is offset i.e. First()+n and LAST()-n.. while first is always a (-ve) number and Last is (+ve).
Can you please give and an example of window sum calculations for calculating sum of sales for specific partition.