The totality of the current amount in the table?

Question

I have a simple data set showing the number of points scored by a player. It is plotted on the [Week] X axis. I added the Running Sum calculation, like Line, divided by Player (color).

For each week, I would like to determine the top player by the number of points achieved to date.
For example, in Week 3, the top player was GREEN with a total of 8 points.

I tried to create a LOD function {FIXED [WEEK]: MAX(RunningSum)}, but it complains that I cannot aggregate the aggregate.
I tried WINDOW_MAX (), RANK () and tried to set up the Calc Calc, Advanced, Partitioning and Addressing function.

Is there no way to identify MAX from the collection of current totals as discrete [Week Number]?

TSQL, Window .

Answer 1

RANK(), , Player. , [RunningSum] :

RUNNING_SUM(SUM([Points]))

( [Player Rank]):

RANK([RunningSum])

. Calculated Field ( "" "" ), - " " ).

, " :" "".

[Player Rank] .