Select distinct value for each ID, then sum all values across IDs without ignoring duplicates?

[AyCe1082]

Hi,

I had cumulative values for each player ID so I used the script to only get the max value per Game_Date as shown below. That is the max value repeated per row for one player per date.

I can get the distinct for each player and sum them as a single row in a straight table with Dimensions reducing the data then using

=sum({<HOME_TEAM_NAME = , AWAY_TEAM_NAME, GAME_DATE, LAST_NAME>}aggr(Only({<PLAYERTEAMNAME2={'$(vTeam2)'},HOME_TEAM_NAME = , AWAY_TEAM_NAME = ,GAME_DATE =, LAST_NAME = >} MAX_VERY_HIGH_SPEED_TIMES),MAX_VERY_HIGH_SPEED_TIMES))

My issue is that if multiple players have the same max value like above, the 'duplicates' are ignored when I try to use it as an expression to create just the total in a row (or text object).

Is it possible to take the distinct value per player per game, then sum them all without the distinct function removing duplicates?

[sunny_talwar · Accepted solution]

May be you need this

=Sum({<HOME_TEAM_NAME, AWAY_TEAM_NAME,  GAME_DATE,  LAST_NAME>} Aggr(

Only({<PLAYERTEAMNAME2 = {'$(vTeam2)'}, HOME_TEAM_NAME,  AWAY_TEAM_NAME, GAME_DATE, LAST_NAME>} MAX_VERY_HIGH_SPEED_TIMES)

, GAME_DATE, LAST_NAME))

[AyCe1082]

Thank you very much, that is exactly what I needed.