2 Replies Latest reply on Apr 27, 2018 1:30 PM by Jim Moroney

    Comparing a selection to the remainder

    Jim Moroney



      I would like to be able to compare a set of selected values to the remainder of the data.  For example my data would be:


      Group        Value

      Group 1     100

      Group 2     200

      Group 3     300

      Group 4     400


      If I select/filter Group 1 and Group 2 I would get a value of 300.  I would like to compare that number to the remainder (Group 3/Group 4) which is 700.  This way I can dynamically compare my selection against the balance of the data.  The goal is to compare one group against the other through selection. Any help would be appreciated. Thanks.