There are three arguments defined in the syntax used for the Above() function:
- Expression = Sum(Sales)
- Offset = '0'
Since this is zero, the function evaluates the expression on the current row.
- Count = RowNo(Total)
The third argument tells the Above() function to evaluate the expression over a range of values. In this case, because we are specifying a total inside the Rowno() function, the result would be the number of the row the user is currently on.
The Above() function will return a range of values. Hence, we will use the RangeSum() function to sum up all the values.