6 Replies Latest reply: Jun 8, 2018 3:23 AM by Tresesco B RSS

    HELP in SUM

    Reynaldson Aceberos

      Good day to all

       

       

      i got this data,

       

      what i want to do is if i filter the Reference to 2 and the


      sum of amount must be 300 coz of reference 1+2 = Amount 100+200

       

      i use this formula  " Sum({<Reference={"<=$(=Max(Reference))"}>}[Amount]) "

                                    

      i got it right if i select in the filter 1 and 2 but it doest work if i select in the filter only the 2

       

       

      ReferenceAmount
      1100
      2200
      3300
      4400

       

       

      does anyone have an idea how to compute it

       

       

      thanks...