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"