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

# Using SUM within Set Anlysis

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

• ###### Re: Using SUM within Set Anlysis

May be this

Sum({<[Field] = {'Source1'}, Month = {"=Sum({<[Field] = {'Source1'}>} [Measure1]) > 0"}>} [Measure1])

Sum({<[Field] = {'Source1'}, Month = {"=Sum({<[Field] = {'Source1'}>} [Measure2]) > 0"}>} [Measure2])

Sum({<[Field] = {'Source1'}, Month = {"=Sum({<[Field] = {'Source1'}>} [Measure3]) > 0"}>} [Measure3])

Sum({<[Field] = {'Source1'}, Month = {"=Sum({<[Field] = {'Source1'}>} [Measure4]) > 0"}>} [Measure4])

• ###### Re: Using SUM within Set Anlysis

It works! Thank you!