Enterprise Reporting Test - Period to Period Reports
Trends are a key metric in sales. They require period to period calculations. It's not unusual to get questions like these.
How did we do against last quarter? Against the same quarter a year ago?
Being able to answer them quickly and easily is important. Here's a simple report.
Can the product you are looking at do it from the
data as it is. Remember no DBA building new tables and no 3GL code.
|Product Line Sales for Current Quarter
||% Change from Last Qtr
Here's a little twist can you use the same code to provide a report with whatever
the user wants - units, dollar volume, or margin?
How about color coding the % change based on the value?
Can you do a drill down from the products?
How much effort is it going to be to turn this into a graph, a PDF file,
or an Excel
Can you do inter-row calculations?
Can you have hidden data for calculations?
Copyright © 1999, 2000, 2001 InfoDesign Inc. All rights reserved.
Revised: July 05, 2001
FOCUS, WebFOCUS, COPY MANAGER, IBI are all registered
trademarks of Information Builders, Inc., NY, NY