sum(sales) orsum({$}
sales)
|
sales in current selection
|
sum({1} sales})or sum({1}
Total sales})
|
sales disregarding the
selection or disregarding selection and dimension
|
sum({$<OrderDate
= DeliveryDate>} sales)
|
sales in current selection
for a specific date
|
sum({1<Region
= {US}>} sales)
|
total sales for region=US
|
sum({<Region
= >} sales)
|
sales in selection with
region removed (idem $)
|
sum({$<Year={2000},
Region = {"U*"}>} sales)
|
current selection but year
forced to 2000 and region like U*
|
sum({$<Year
= {$(vLastYear)}>} sales)
|
sales related to a
variable
|
p({<Year={$(=max(Year)-1)}>}
customer)
|
returns customers who are
possible for last year
|
e({<Year={$(=max(Year)-1)}>}
customer)
|
returns customers who are
excluded for last year
|
