agregation function

[#1]

hi

i am trying to make an agregtion function-( Sum) on tickets sales. i want to "sum" the sales just when it is the first week (i have a colom with the week number so i want to sum just when the value on this colom =1) and to show it per day on the week..

how can i do it when i write the function SUM(TICKETS----------

TNX

[brenner_martina]

Hi, liavganot,

sum(If(expression of the column=1, Sales))

or

Sum(If(Column(1)=1, Sales))