RCOUNT( value [ , direction ] [ TOTAL | WITHIN [ dim1, ... ] | AMONG [ dim1, ... ] ] [ ORDER BY ... ] )
Returns the count of all values in a growing (or shrinking) window defined by the sort order and the value of
||Starts from the first row and ends at the current row.|
||Starts from the current row and ends at the last row.|
"asc" is used.
Only constant values are accepted for arguments (
The sorting order is based on the fields listed in the chart's sorting section and in the function's
ORDER BY clause. First,
ORDER BY fields are used, and then they are complemented by the fields from the chart.
RCOUNT([Profit], "desc" WITHIN [Date])
RCOUNT([Profit] AMONG [Date])
Data source support
Microsoft SQL Server 2017 (14.0),