#119 — Group by the Expression

Problem description & analysis: Here below is a data table: Task: We want to group and aggregate by the first two digits of ID, and calculate the total sales of each group. Solution: Use SPL XLL and enter the following code: =spl("=E(?1).groups(left...