I have a field, [Game Date] for which there is the potential to have several data points associated to one particular [Game Date].
Example,
[Game Date] = 10/5/2017
totalsale = $171
qtysold = 2
however, there is also
[Game Date] = 10/5/2017
totalsale = $126
qtysold = 2
How do I show both instances of this [Game Date] as there are two separate transactions.
I am showing this in a table and used the expression: =FirstSortedValue(DISTINCT TOTALSALE, -[Game Date]), which only returns the first value. I am looking to return both (or however many there are) values
