https://bugs.documentfoundation.org/show_bug.cgi?id=161159
--- Comment #7 from Nicholas Becker <[email protected]> --- (In reply to Óvári from comment #0) > 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 https://driftbossgame.co/ > > 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 I got it -- You are receiving this mail because: You are the assignee for the bug.
