Excluding selections for expression with set modifiers
In my QV document I have 3 rows of data. The first row is the row that I would like to have change based on the current selections. The second is a total row that should remain static and should be equal to the first when there are no selections (ie. the Total). And a third line that compares the first two lines.
This is easily accomplished for normal expression that just require a sum(ALL variable) expression. Where I'm running into trouble is the formulas for the first row that already have set modifiers in them.
Here is an example of one such expression from the first row: