ExcelBanter - Add PivitField to PivotCache

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Add PivitField to PivotCache (https://www.excelbanter.com/excel-programming/373687-add-pivitfield-pivotcache.html)

Simon Shaw

Add PivitField to PivotCache

Hi,

Can I programatically add new PivotFields to a PivotCache. Where the
PivotCache is linked to an external database? I would want to then add
PivotItems to the new PivotField.

Tom Ogilvy

Add PivitField to PivotCache

PivotFields are based on what is in the data. If you want to add a
calculated pivotfield, you do that in the pivottable itself.

--
Regards,
Tom Ogilvy

"Simon Shaw" <simonATsimonstoolsDOTcom wrote in message
...
Hi,

Can I programatically add new PivotFields to a PivotCache. Where the
PivotCache is linked to an external database? I would want to then add
PivotItems to the new PivotField.

All times are GMT +1. The time now is 09:19 PM.