Set Analysis-II

Expression	Meaning
sum({$­<Ye­ar=­{2000}, Country = {"U*­"­}>} revenue)	Current selection but year forced to 2000 and region like U*
sum({$­<Year = {$(vLa­stY­ear­)}>} revenue) sum({$­<Year = {$(=vLa­stY­ear­)}>} revenue)	Revenue related to a variable (With or without = sign in front of variable
p({<Ye­ar=­{$(­=ma­x(Y­ear­)-1­)}>} customer)	Returns customers who are possible for last year
e({<Ye­ar=­{$(­=ma­x(Y­ear­)-1­)}>} customer)	Returns customers who are excluded for last year
Sum({1-$} [Sales])	sum of the sales of the « database » except the current selection
Sum({<Flag = {1}, Year={2014}, Month= >} revenue)
Sum ({<customer _name = {“x”, “a”, ”p”}>} revenue) Sum ({<customer _name = {‘x’, ‘a’, ‘p’}>} revenue) Sum ({<customer _name = {[x], [a], [p]}>} revenue) Sum ({<customer _name = {x, a, p}>} revenue)
Sum ({<customer _name = {“x*”, “a?”, “?p*”}>} revenue)	* = 0 to several characters (x* will return x1, x01, x21 …) ? = 1 character (a? will return a1, a1 … but not a11)
Sum ({<customer _name = {“*”} - { “a*”}>} revenue) Sum ({<customer _name =  - { “a*”}>} revenue)	All customers except those whose name begins with a
Sum ({< customer _name += {"abc*"}>})	All customers  of the  current selection + those whose name begins with abc
Sum ({< customer _name -= {"abc*"}>})	All customers  of the current selection - those whose name begins with abc