6 Replies Latest reply on May 6, 2013 11:30 AM by Stuardo Herrera

    Compare individual row with agregated rows

    Stuardo Herrera

      Hi! I want to create a bullet graph that compares a measure with the same measure but agregated. The table looks something like this:

       

      RegionSub-RegionMeasure
      Region 1Sub-Region 112
      Region 1Sub-Region 222
      Region 2Sub-Region 318
      Region 2Sub-Region 423
      Region 3Sub-Region 511
      Region 3Sub-Region 617

       

      The user selects a measure of a certain region and a certain subregion through the use of filters. I want the bullet graph to show the measure selected by the user, and a sum of all measures by region or sub-region.

       

      Thank you for your help!