How to group date-and-time data
Select the column that contains the date-and-time data. From the context menu, choose GroupAdd Group.
Type a number to indicate the grouping for the selected interval type. For example, if you selected Weeks, type 2 to group data in two-week periods.
Figure 5-11 shows grouping the Shipped Date column by month.
Figure 5-11  

Additional Links:

Copyright Actuate Corporation 2012