AnsweredAssumed Answered

Graph Multiple subsummary totals of a found set in the Y axis?

Question asked by poetald on May 26, 2011
Latest reply on May 27, 2011 by philmodjunk

Title

Graph Multiple subsummary totals of a found set in the Y axis?

Post

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"

HELP!!

Screen_shot_2011-05-26_at_4.49.04_PM.png

Outcomes