I am trying to filter the data on the basis of condition
it is like
select count(timesheet_ref),timesheet_date
from export_data
where export_status = 1
group by timesheet_date
eg
report columns
timesheet_ref timesheet_date ready_to_sent(having 2 rows) Already_sent(another table data having 10 rows)
123 1/12/2013 1 4
124 2/12/2013 1 6
------------------------------------------------------------------------------------------------------------
Total 10(it should give2) 10
--------------------------------------------------------------------------------------
to make it we need to use this formula
for total should be = sum(count([export_data.timesheet_ref]))
but above formula is not working.
Please help