pivot table calculated field with user function
Is it possible/how do I use a user function for a pivot table
calculated field? Something like the following: With pt .AddFields RowFields:="Vendor", ColumnFields:="Channel" .PivotFields("Name").Orientation = xlDataField .CalculatedFields.Add name:="BlueBox", Formula:="=CountBlueBox(Name,Channel)" With .PivotFields("BlueBox") .Orientation = xlDataField End With End With I don't seem to understand how to specify the function CountBlueBox as the Formula. |
pivot table calculated field with user function
To the best of my knowledge you can not use a UDF with a Pivot Table. You
could add an extra column into your source data and add the UDF value to that column perhaps... -- HTH... Jim Thomlinson "puff" wrote: Is it possible/how do I use a user function for a pivot table calculated field? Something like the following: With pt .AddFields RowFields:="Vendor", ColumnFields:="Channel" .PivotFields("Name").Orientation = xlDataField .CalculatedFields.Add name:="BlueBox", Formula:="=CountBlueBox(Name,Channel)" With .PivotFields("BlueBox") .Orientation = xlDataField End With End With I don't seem to understand how to specify the function CountBlueBox as the Formula. |
pivot table calculated field with user function
Thanks for the information. I was affraid of that. I ended up having
to make another table. |
All times are GMT +1. The time now is 12:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com