Description: GroupBy function https://support.microsoft.com/en-us/office/groupby-function-5e08ae8c-6800-4b72-b623-c41773611505 The GROUPBY function allows you to group, aggregate, sort, and filter data based on the fields you specify. https://bettersolutions.com/excel/functions/groupby-function.htm --- PivotBy function https://support.microsoft.com/en-us/office/pivotby-function-de86516a-90ad-4ced-8522-3a25fac389cf The PIVOTBY function allows you to create a summary of your data via a formula. It supports grouping along two axis and aggregating the associated values. For instance, if you had a table of sales data, you might generate a summary of sales by state and year. https://bettersolutions.com/excel/functions/pivotby-function.htm --- PercentOf function https://support.microsoft.com/en-us/office/percentof-function-7c66da0a-ac30-45d0-bfc7-834a8bd7c962 Use the PERCENTOF function to return the percentage that a subset makes up of a given data set. It commonly used in GROUPBY and PIVOTBY functions. Note: PERCENTOF is logically equivalent to =SUM(data_subset)/SUM(data_all) --- Excel - First Look at Amazing GroupBy PivotBy PercentOf Functions in Excel - Episode 2633 Published on Nov 15, 2023 https://www.youtube.com/watch?v=6jP7DflN4sw Functions benefit from Lambda and Eta-Lambda functions https://bugs.documentfoundation.org/show_bug.cgi?id=138749 Steps to Reproduce: - Actual Results: - Expected Results: - Reproducible: Always User Profile Reset: No Additional Info: Excel - First Look at Amazing GroupBy PivotBy PercentOf Functions in Excel - Episode 2633 Published on Nov 15, 2023 https://www.youtube.com/watch?v=6jP7DflN4sw Functions benefit from Lambda and Eta-Lambda functions https://bugs.documentfoundation.org/show_bug.cgi?id=138749
+1
(In reply to m_a_riosv from comment #1) > +1 Can you please update the Status from UNCONFIRMED to NEW? Thank you
I can, but would be fine having more opinions.