I have two fields, [Opportunity ID] and [updated Date]. As there can be multiple changes associated on one ID, I want to only pull the lastest Date listed with that ID.
If not, the same ID will be listed multiple times with a value amount that will be double counted.
Im doing this in a straight table with chart properties and so can be done within the Dimensions or Expressions.
Could it be something like? All help much appreciated
=Max(Date(if( [Opportunity.ID] = [Opportunity.ID], [updated Date]))
May be this as calculated dimension
Aggr(If([updated Date] = Max(TOTAL <[Opportunity.ID]> [updated Date]), [Opportunity.ID]), [Opportunity.ID], [updated Date])
View solution in original post
nice one - worked a charm