2 Replies Latest reply: Aug 10, 2018 9:53 AM by Hannah Cozad RSS

    Using SUM within Set Anlysis

    Hannah Cozad

      Hello, I have a line chart that shows 4 measures, like those below, and a Month dimension. I want to limit those to show when the sum of measure 1 is > 0 for each month.

       

      Current Expressions:

      SUM({<[Field]={'Source1'}>} [Measure1] )

      SUM({<[Field]={'Source1'}>} [Measure2] )

      SUM({<[Field]={'Source1'}>} [Measure3] )

      SUM({<[Field]={'Source1'}>} [Measure4] )

       

      This is what I want:

      SUM({<[Field]={'Source1'}, SUM({<[Field]={'Source1'}>} [Measure1] ) > 0 >} [Measure1] )

      SUM({<[Field]={'Source1'}, SUM({<[Field]={'Source1'}>} [Measure1] ) > 0 >} [Measure2] )

      SUM({<[Field]={'Source1'}, SUM({<[Field]={'Source1'}>} [Measure1] ) > 0 >} [Measure3] )

      SUM({<[Field]={'Source1'}, SUM({<[Field]={'Source1'}>} [Measure1] ) > 0 >} [Measure4] )

       

      Can someone help me with the syntax or know of another way to do this?

       

      Thanks1