Filter
Top Products
CHAPTER 15 Working with Graphs
DataWindow Designer User’s Guide 435
Here is the resulting graph:
Graphing unit sales by
representative and
total sales
To graph quarterly sales made by each representative, plus total sales for each
printer, create a graph with the following settings on the Data page in the
Properties view:
•Set Rows to
All
• Set Category to quarter, "Total"
• Set Value to sum(units for graph), sum(units for graph)
• Select the Series check box
• Set Series to
rep, rep
Here you have two types of categories: the first is Quarter, which shows
quarterly sales, as in the previous graph. You also want a category for total
sales. There is no corresponding column in the DataWindow object, so you can
simply type the literal “Total” to identify the category. You separate multiple
entries with a comma.
For each of these category types, you want to graph the sum of units sold for
each representative, so the Value and Series values are repeated.