https://bugs.documentfoundation.org/show_bug.cgi?id=161159
Bug ID: 161159
Summary: Add GROUPBY, PIVOTBY, PERCENTOF functions to Calc
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
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
--
You are receiving this mail because:
You are the assignee for the bug.
