Cisco Systems OL-24201-01 Camera Accessories User Manual


 
13-51
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13 Managing Reports
Organizing Report Data
Step 4 To set a grouping interval, select Group every and enter a value and select the grouping interval.
For example, to create a new group for every month, type 1 and select Month from the drop-down list.
The report displays monthly data groups, as shown in Figure 13-36.
Figure 13-36 Data Grouped by Month
Removing an Inner Group
To remove an inner group:
Step 1 Select and right-click the column for the group you want to remove.
Step 2 From the context menu, select Group > Delete Inner Group.
Creating Report Calculations
Most reports require some sort of calculations to track sales, finances, inventory, and other critical
business activities. You might want to keep a simple count of items in a warehouse or you might need to
provide more complex financial data such as tracking stock portfolio performance over time.
You can use typical mathematical functions such as counting, addition, subtraction, multiplication, and
division. In addition, you can write expressions that extend these basic functions.
To display calculated data in a report, you create a calculated column, such as the one shown in
Figure 13-37. In this illustration, the Item Totals column displays the product of the unit price times the
quantity.