Forum Discussion
rlussky
Helper I
Helper ITop N or Rank Dynamic By Date
Hello, I am struggling to create a summation of values by top 5 states that is dynamic by date. On the left in my screenshot is a table of data, while the red section on the right is a summary th...
rlussky I'm seeing different top states than you listed above in your data, but how about something like this:
TOP 5 States = VAR _TopStates = TOPN(5, 'Table',[Balance Measure]) VAR _Result = CALCULATE([Balance Measure],_TopStates) RETURN _Result
rlussky I'm seeing different top states than you listed above in your data, but how about something like this:
TOP 5 States =
VAR _TopStates = TOPN(5, 'Table',[Balance Measure])
VAR _Result = CALCULATE([Balance Measure],_TopStates)
RETURN
_Result