I am trying to count the total teams with a 'Y' usage for the current reporting period.
WHERE the Usage Flag is 'Y'
AND
The Report Date is the maximum for the current 'reporting period'. See below for data example
= count( {$< [Usage] = {"Y"}, [Report Date] = {"$(=Date(max([Report Date]))"}>} RecordID)
Total Should equal 1 because the max date is 4/1/2018
| RecordID | Team | Usage | Report Date |
| 1 | A | Y | 1/1/2018 |
| 2 | B | N | 1/1/2018 |
| 3 | C | Y | 1/1/2018 |
| 4 | A | N | 2/1/2018 |
| 5 | B | Y | 2/1/2018 |
| 6 | C | N | 2/1/2018 |
| 7 | A | Y | 3/1/2018 |
| 8 | B | Y | 3/1/2018 |
| 9 | C | Y | 3/1/2018 |
| 10 | A | N | 4/1/2018 |
| 11 | B | N | 4/1/2018 |
| 12 | C | Y | 4/1/2018 |
