New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Support for the GetPivotData function - PivotTable Calculations #1410

Open

JanKallman opened this issue Apr 10, 2024 · 0 comments

Assignees

Labels

Milestone

Contributor

JanKallman commented Apr 10, 2024 •

edited

Calculation of pivot tables:

Calculating Data Fields on rows and columns:

Functions:
- Sum
- Count
- Average
- Min
- Max
- Product
- Count Numbers
- StdDev
- StdDevP- Var
- VarP
Show Value As
- % of Grand Total
- % of Column Total
- % of Row Total
- % Of
- % of Parent Row Total
- % of Parent Column Total
- % of Parent Total
- Difference From
- % Difference From
- Running Total in
- % Running Total in
- Rank smallest to largest
- Rank largest to smallest
- Index
Sorting
Page fields
Filters
- Caption filters
- Numeric Filters
- Date & Time Filters
- Value Filters
- Top/bottom filters
- Slicers
Calculated Fields

New Functions and Properties

ExcelPivotTable.Calculate method
ExcelPivotTable.GetPivotData method
ExcelPivotTable.IsCalculated property
ExcelFunction.IsAllowedInCalculatedPivotTableField property

JanKallman added the enhancement label

JanKallman self-assigned this

JanKallman added this to the 7.2 milestone

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment