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
rlusskyHelper I
Helper IWow, that was much more simple than I thought it would be.
Thanks Anonymous !