ExcelBanter - pivot tables custom formulas

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - pivot tables custom formulas (https://www.excelbanter.com/excel-discussion-misc-queries/85877-pivot-tables-custom-formulas.html)

kvail

pivot tables custom formulas

Can the PivotTable Field contain a user defined formula to summarize by...

For example: I want to have one field that provides the % of data points
that are equal to 4 or 5

Debra Dalgleish

pivot tables custom formulas

You can't use User Defined Formulas in a pivot table calculation.

kvail wrote:
Can the PivotTable Field contain a user defined formula to summarize by...

For example: I want to have one field that provides the % of data points
that are equal to 4 or 5

All times are GMT +1. The time now is 02:28 PM.