6 Replies Latest reply: Mar 2, 2017 12:21 PM by Sunny Talwar RSS

    Force sum on higher level

    Jonah Van Quekelberghe

      Hello,

       

      I would like to force a sum on a certain level independant of the selections in a lower level.

       

      Example:

         

      GroupDetailValueValue forced
      AA-1228
      AA-2328
      AA-3528
      AA-4728
      AA-51028
      AA-6128

       

      I can show the forced value for group A via the TOTAL function : sum(TOTAL<Group> value).

      But if I do a selection within the group (select A-1 and A-2 for example), I would like to keep the 28, with the above formule it wil give the total of the selection (see below).

          

      GroupDetailValueValue forcedValue with current function
      AA-12285
      AA-23285

       

      In a dashboard i'd like to show the total value of A even if i only selected A-1

       

       

      Thanks in advance for the help.

      Jonah