How do I create an expression for a count of the number of records in a table that is conditioned by another row in the the table?
for example, the script below produces the total number of records, whereas I want total number of records created on or after 1st August 2012
Load count(distinct [rec key]) as [record Count]
(biff, embedded labels, table is Sheet1$)
WHERE([record Created] <= '01/08/2012') ;