#89 — Calculate Proportion Using the Aggregation Values of the Data from the Same Group

Problem description & analysis: Here below is an annual and quarterly sales data table: Task: Calculate the proportion of each quarterly sales to the total sales of the year (to calculate in cell D1). Solution: Use SPL XLL and the code is as follows...