1 Reply Latest reply on May 27, 2011 9:30 AM by philmodjunk

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

    poetald

      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