esProc Desktopesproc-desktop.hashnode.dev·Nov 5, 2024#89 — Calculate Proportion Using the Aggregation Values of the Data from the Same GroupProblem 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...10 likes#Excel-tutorialAdd a thoughtful commentNo comments yetBe the first to start the conversation.
