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

This content originally appeared on DEV Community and was authored by Judith-Excel-Sharing

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:

=spl("=E(?1).group(Year).((a=~.sum(Sales),~.(Sales/a))).conj().new(~:Proportion)",A1:C21)
The results are shown below:

Download esProc Desktop for FREE and streamline datasheets with ease!!! 🚀🔥⬇️

✨SPL download address: esProc Desktop FREE Download

✨Plugin Installation Method: SPL XLL Installation and Configuration

✨References to other rich Excel operation cases: Desktop and Excel Data Processing Cases

✨YouTube FREE courses: SPL Programming

This content originally appeared on DEV Community and was authored by Judith-Excel-Sharing

Print Share Comment Cite Upload Translate Updates

APA

Judith-Excel-Sharing | Sciencx (2024-11-05T02:50:34+00:00) #89 — Calculate Proportion Using the Aggregation Values of the Data from the Same Group. Retrieved from https://www.scien.cx/2024/11/05/89-calculate-proportion-using-the-aggregation-values-of-the-data-from-the-same-group/

MLA

" » #89 — Calculate Proportion Using the Aggregation Values of the Data from the Same Group." Judith-Excel-Sharing | Sciencx - Tuesday November 5, 2024, https://www.scien.cx/2024/11/05/89-calculate-proportion-using-the-aggregation-values-of-the-data-from-the-same-group/

HARVARD

Judith-Excel-Sharing | Sciencx Tuesday November 5, 2024 » #89 — Calculate Proportion Using the Aggregation Values of the Data from the Same Group., viewed ,<https://www.scien.cx/2024/11/05/89-calculate-proportion-using-the-aggregation-values-of-the-data-from-the-same-group/>

VANCOUVER

Judith-Excel-Sharing | Sciencx - » #89 — Calculate Proportion Using the Aggregation Values of the Data from the Same Group. [Internet]. [Accessed ]. Available from: https://www.scien.cx/2024/11/05/89-calculate-proportion-using-the-aggregation-values-of-the-data-from-the-same-group/

CHICAGO

" » #89 — Calculate Proportion Using the Aggregation Values of the Data from the Same Group." Judith-Excel-Sharing | Sciencx - Accessed . https://www.scien.cx/2024/11/05/89-calculate-proportion-using-the-aggregation-values-of-the-data-from-the-same-group/

IEEE

" » #89 — Calculate Proportion Using the Aggregation Values of the Data from the Same Group." Judith-Excel-Sharing | Sciencx [Online]. Available: https://www.scien.cx/2024/11/05/89-calculate-proportion-using-the-aggregation-values-of-the-data-from-the-same-group/. [Accessed: ]

rf:citation

» #89 — Calculate Proportion Using the Aggregation Values of the Data from the Same Group | Judith-Excel-Sharing | Sciencx | https://www.scien.cx/2024/11/05/89-calculate-proportion-using-the-aggregation-values-of-the-data-from-the-same-group/ |

Please log in to upload a file.

There are no updates yet.
Click the Upload button above to add an update.

You must be logged in to translate posts. Please log in or register.