deleting pivot table field
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
03-02-22 07:13 AM
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
------------------------------
Is their any code available for this
------------------------------
varsha kanthikar Senior Software engineer
Senior Software Engineer
persistent systems limited
Indiana
7517645366
------------------------------
2 REPLIES 2
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
03-02-22 07:28 AM
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
------------------------------
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
------------------------------
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
09-02-22 10:27 AM
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:
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
------------------------------
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
------------------------------
