2
Count values of field "Customer" based on the
current selection
Count({$}Customer)
3
Sum of "Sales" based on
all values, ignoring any selection.
Sum({1}Sales)
5
Calculate the sum of "Sales" for
everything that the current selection excludes.
Sum({1-$}Sales)
8
Calculate the sum of "Sales" based on the
2nd previous selection.
Sum({$2}Sales)
9
Calculate the
sum of the expression "ItemsSold*ItemPrice" based on the
current
selection.
Note: Be carefull when using expressions within a Set Analysis expression!
Sum({$}ItemsSold*ItemPrice)