Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
(sum({1<[FIS YEAR]={'2017'}>} UNITS))-(sum(UNITS))
This should give me all of 2017 units, ignoring dimension selection, minus 2018 units.......but it does not, in fact, it does not subtract at all.
just get 2017 total units. zits as if it completely ignores the subtraction.
what am I doing wrong?
Thank you.
To ignore the "selections" that the dimensions do you will have to use the TOTAL qualifier in the aggregations. The 1 set identifier will affect the normal user selections and won't affect the dimension "selections"/groupings.
(Sum(TOTAL <Dim1> {1<[FIS YEAR]={'2017'}>} UNITS))-(Sum(TOTAL <Dim1> {1} UNITS))
This is how it's done keeping one (grouping) dimension but ignoring the rest of the dimensons.
