2 Replies Latest reply on Jun 1, 2016 2:38 AM by Sidhu Suresh

    Creating calculated field unaffected by filter

    Sidhu Suresh

      Hi,

       

      I am facing a logical issues. My data is something like this
       

      Proj NameValue
      A1988
      A4227
      A4763
      B2333
      B3574
      C4327
      C1485
      C

      2905

      I need a drop down selection which shows only B & C, but SUM([Value]) should be sum of value for A + sum of value for the selection.

      Eg. From the drop down if I select B, it should give sum of A + sum of B.

      I need the filter to be dynamically change upon updating new rows of Proj Name (Parameter usage can be eliminated).