2 Replies Latest reply: Mar 27, 2012 2:57 PM by Marc Livingston RSS

    Write Expression to include a sum of multiple "Groups" AND one of those Groups as two fields in a chart

      I am struggling to write the expression needed to output two types of data into a single chart. I would like to have two bars in a chart: 1) Bar 1 would be the sum of 5 different groups, and 2) Bar 2 would be one of those 5 groups.

       

      Of what you see below, I'd like to have one bar be the sum of all of the [QP.SourceGroup] types in my current expression, and the other bar be the [QP.SourceGroup]='Warranty' seperate from the sum bar.

       

      PLEASE HELP