Calculate Subtotal Week Dates

building reports desktopintelligence
1

Hi,

Can anyone tell me how to get subtotals for week 1 and week2?

For example I enter dates: Begin: 12/13/2009 AND End: 12/26/2009
Week starts:Sunday Ends:Saturday.

I have the dates and number of hours worked during that period.

How do I get subtotals for each week?

ex: 12/13/2009 to 12/19/2009 = 40 hours.
12/20/2009 to 12/26/2009 = 40 hours.
Hope this makes sense!

Thanks
:?

eye_candy :us: (BOB member since 2005-03-18)

2

What are your LOVs. Only Selected dates or All the dates. so user can select only Sunday or Any day.

Rakesh_K :india: (BOB member since 2007-12-11)

3

Use the Week number functionality within the reporter tool.
Break on week, total it.