topic RE: deleting pivot table field in Product Forum

deleting pivot table field

varshakanthikar — Thu, 03 Feb 2022 07:13:00 GMT

I want to delete one pivot fields from value field.

Is their any code available for this

------------------------------
varsha kanthikar Senior Software engineer
Senior Software Engineer
persistent systems limited
Indiana
7517645366
------------------------------

RE: deleting pivot table field

PabloSarabia — Thu, 03 Feb 2022 07:28:00 GMT

Hi!

Sorry, can yo please give us some information? Witch wich kind of object are you working for?

Bye 🙂

------------------------------
Pablo Sarabia
Architect
Altamira Assets Management
Madrid
634726270
------------------------------

RE: deleting pivot table field

AndreyKudinov — Wed, 09 Feb 2022 10:27:00 GMT

I assume you want to do it in excel, although you dont mention it anywhere.

If you record a macro and check what excel does when you remove a field, you get something like this:
Dim xlInstance = GetInstance(handle)
Dim xlWorkbook As Object = GetWorkbook(handle, workbookname)
xlWorkbook.ActiveSheet.PivotTables(pivotname).PivotFields(pivotfield).Orientation = xlHidden

You can add this as new action to excel VBO. Assuming you know "pivotname", Otherwise you could probably use index or add some code to find pivotname.

------------------------------
Andrey Kudinov
Project Manager
MobileTelesystems PJSC
Europe/Moscow
------------------------------