3 Replies Latest reply on Dec 21, 2017 12:36 PM by Michael Ye

    LOD question

    Jessie Wang
      DimensionMetricsTotal
      A419
      B219
      C319
      D619
      E319
      F119
      G319
      Total 2219
      if Category <> 'G' Then [Metrics]

       

      -------------->

       

        

      aMetrics
      A419
      B219
      C319
      D619
      E319

       

      Hello everyone,

       

      So my data is at above 1st table, I want to get the total excluding 'G' value (basically I am expecting 19 not 22)

      but when I report, I want to display it like table 2, I will only display value from  A - E, the question is how do I get the total 19 without listing all values and at the same time exclude 'G' from totaling

       

      Thanks and Happy holidays