Graph Multiple subsummary totals of a found set in the Y axis?
The X axis is the Salesperson
The Y axis are the Subsummary totals of the Sales status for Clients
How do you graph the Y axis when there are several subsummary totals, one for each client status. In other words, for a single salesperson, if 50 clients are grouped by their Sales Status as either a Lead, Opportunity, Proposal, Presentation or Contract, each of these has a subtotal. I want to graph each subtotal but the graph Y-axis only wants to recognize the combined total of all the SalesStatus subtotals (i.e. "19" from the screenshot below).
I unsuccessfully tried the following Calculation for the Y axis :
Subsummary SalesStatus = "Lead"
Subsummary SalesStatus = "Opporunity"
Subsummary SalesStatus = "Proposal"
Subsummary SalesStatus = "Presentation"
Subsummary SalesStatus = "Contract"
Assuming that the values you want in your chart are the Bold faced record counts in your screen shot, simply refer to that summary field as the Y access value and Sales progress would be used for the X axis. Then select the "use data from current found set" and "show data for groups of records when sorted" options. Then sort your records by Sales Progress.