Filter
Top Products
13-52
User Guide for Cisco Secure Access Control System 5.4
OL-26225-01
Chapter 13 Managing Reports
Organizing Report Data
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.
Figure 13-37 Calculated Column
To create a calculation, you
• Provide a title for the calculated column.
• Write an expression that indicates which data to use and how to display the calculated data in the
report.
The expression contains a function and one or more arguments. Arguments indicate the data you
want to use to create the calculation.
As shown in Figure 13-38, when you type the first letter of a function name in Enter Expression,
Calculation presents a list of functions that begin with that letter. You select a function and provide
the arguments.