9 Replies Latest reply: Mar 14, 2018 8:56 AM by Archana handu RSS

    Filter data based in table on measure

    Archana handu

      Hi ,

       

      Is it possible to filter Data in table report based on measure value ?

       

      my Requirement is to eliminate rows where sum(M1+M2)=0

         

      DimM1m2
      AA100344
      BB65533
      CC333-333
      DD44-44
      EE2344432
      FF323-323
      GG3534666

       

       

      e.g : in above example  I  want to Hide( Dim CC,DD,FF as sum of M1 & M2 =0 for these dim rows.) in my report.

       

      Any help is highly appreciated.