G
Guest
I have the date field [Contact Date]. I have weekly report that counts the
not null data in [Contact Date], the report uses "Between [date1] and
[date2]" to create a count of this field in the report. A monthly report is
created using the same criteria of "between-and". No problem on these reports.
My boss wants now a report that shows the weekly count AND the monthly count
in the same report. weekly count is based on Mon-Fri and monthly count on
calendar days (first day-last day of the month). Example:
week 1: 10
week 2:10
Week 3:10
Total: 30 (eventhough is not the end fo the month)
At this point she gets a weekly report and a montlhy report. She wants the
cumulative totals in the weekly report in order to get rid off the monthly
one.
I hope my question makes sense, i check the discussions data and could not
find something similar that could help me.
Thank you for your help.
not null data in [Contact Date], the report uses "Between [date1] and
[date2]" to create a count of this field in the report. A monthly report is
created using the same criteria of "between-and". No problem on these reports.
My boss wants now a report that shows the weekly count AND the monthly count
in the same report. weekly count is based on Mon-Fri and monthly count on
calendar days (first day-last day of the month). Example:
week 1: 10
week 2:10
Week 3:10
Total: 30 (eventhough is not the end fo the month)
At this point she gets a weekly report and a montlhy report. She wants the
cumulative totals in the weekly report in order to get rid off the monthly
one.
I hope my question makes sense, i check the discussions data and could not
find something similar that could help me.
Thank you for your help.