
Anonymous
Not applicable
‎2018-07-21
05:25 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hmmmm....
(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.
541 Views
2 Replies

Partner - Champion III
‎2018-07-22
02:59 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

Partner - Champion III
‎2018-07-22
09:12 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
(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.
423 Views
