5 Replies Latest reply on Dec 6, 2013 8:52 AM by cory.tak.0

    How to place a subset of data and the entire data set on the same graph?

    Andrew Capua

      Hi All -

       

      I am looking to create a single bar graph, with two columns. One column would be a total of all the products within a business line. The other column would be just a few of the products from that same business line. I'll use football as an example...

       

      Column A of Graph X

      Dimension: NFL Teams (All 32 NFL teams)

      Measure: Total Points Scored

       

      Column B of Graph X

      Dimension: NFL Teams (Filter on just the Patriots, Giants and Eagles)

      Measure: Total Points Scored

       

      I can easily do this on two separate worksheets, but it is proving to be a challenge to do this on the same sheet.

       

      Thanks!