Set Analysis Help needed

[Anonymous]

I am working on a dashboard i inhabited from a former employee.  it currently uses a month selection, however if you select multiple months the values all move to 0, a majority of calculations are like the one below

sum ( {$<[Ops Year] = {$(#=Only(_YYYY))}, [Ops PdNo] = {'$(#=Only(_MM))'}>} [Revenue-Actual])

I am not sure how to change this so that I can select multiple at a time, i tried the formula below but still my values all changed to 0

sum ( {$<[Ops Year] = {$(#=Only(_YYYY))}, [Ops Month] = {"<=$(#=Only(_MM))"}>} [Revenue-Actual])

Can someone help me so I am able to select say multiple period at once.  I have attached screen shots in the document attached.

[sunny_talwar · Accepted solution]

If that is what you want, why do you even need set analysis... try this

Sum([Revenue-Actual])

This will show you the Sum of whatever is selected.