This example can be used to sum the values in a column based on a condition and organized by group.
The following data identifies sales figures by salespeople for a week:
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:
First you wish to examine weekday sales, when
DayOfWeek < 6. For each day of the week, you can preview the following aggregation:
Performance is listed in the following order: S001, S002, S003.
To analyze the weekend, you change the above to the following:
The following are the results for the weekend: