Sum and date on date difference

[#1]

Hi all,

I have table that looks like this:

I am trying to sum up the goals that each team scored on the latest date (max date). I've created a variable

vMaxDate = (Date(Max(Date)),Team). I've tried 2 expressions and it keeps selecting the largest goals scored. These are my expressions:

(aggr(SUM(if(Date=$(=vMaxDate), Goals,0)),Team))

(if(Date=$(=vMaxDate), Goals,0))

I want my output to look like this:

I also need to calculate a sequential difference based on the date i.e. :

[sunny_talwar · Accepted solution]

Try this in a straight table

Dimension: Team

Expression1: =Date(Max(Date))

Expression2: =FirstSortedValue(Aggr(Sum(Goals), Team, Date), -Aggr(Date, Team, Date))

[sunny_talwar]

For your second requirement create another straight table:

Dimension: Team, Division, Date

Expression1: Goals

Expression2: =Goals - Above(Goals)

[#4]

Thank Sunny T. Works perfectly!