I'm currently experimenting with set analysis. I have a Select Field year=1998. In a pivot table I'm showing sum( turnover ) over the EMPLOYEE_lastname and DATE_MONTH-nr fields. I tried showing the turnover for other years with the expression:
sum( {1-$} turnover )
Surprisingly, this adds a new row with a null value for EMPLOYEE_lastname. I believe wothout the TOTAL qualifier, this is supposed to work within the given dimensions though. Am I overlooking something here?
I'm not sure if this can answer your question completely, but {1-$} will give you the set excluded by the selection (considering all the selecitons in the .QVW). If you want to get the exclusion only in a field, your set analysis would be more like:
sum( { <year= e(year)>} turnover )
Total will only make sense inside an object (or in a Aggr() function) because it will ignore the dimensions (not selections)
