Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.