EXAMPLE - SUMIF Function

Contents:

The SUMIF function can be used to sum the values in a column based on a condition and organized by group. See SUMIF Function.

Source:

The following data identifies sales figures by salespeople for a week:

Transform:

You want to know how your salespeople are doing by the day of the week. To the above, you add a column that identifies the day of the week:

derive type:single value:WEEKDAY(Date) as:'DayOfWeek'

First you wish to examine weekday sales, when DayOfWeek < 6.

For each day of the week, you can preview the following aggregation:

pivot value:SUMIF(Sales, (DayOfWeek < 6)) group:EmployeeId

Performance is listed in the following order: S001, S002, S003

To analyze the weekend, you change the above to the following:

pivot value:SUMIF(Sales, (DayOfWeek >= 5)) group:EmployeeId

Results:

The following are the results for the weekend: