how to ignore the selection of one dimension in a multiple set analysis
I have an set analysis calculation like below in a table, and i want to disregard the selection of the dimension of fiscal year in this case. and i had tried in different ways like below but it didn't work, can you help??
As Jonty has said, you need to include the set analysis in your Aggr as well. Set analysis applies once to the set of data you have in a visualisation, but functions such as Aggr are effectively looping through your total set and thus the set analysis needs to be applied again.
What I meant was, if a selection has been applied to a field, that selection will likely have limited the available range of values for other fields. That's the way the associative model works. Once you select a value, such as a date, you now only have available in your result any records associated with that value. All the values associated with Year -1 for example, won't be available. So clearing just one field in your set analysis is rarely enough, typically you'll need to clear a whole range. It can be a bit of a trap.