Add field in Pivot Table

[RohiniPatil1]

Hi All,

I have created Pivot table by code stage. now I have to add one of the field from it in row and values.

when I record macro I get
  Range("B5").Select
    ActiveSheet.PivotTables("PivotTable").AddDataField ActiveSheet.PivotTables( _
        "PivotTable").PivotFields("Case Comment Created By"), _
        "Count of Case Comment Created By", xlCount
    With ActiveSheet.PivotTables("PivotTable").PivotFields( _
        "Case Comment Created By")
        .Orientation = xlRowField
        .Position = 1
    End With

can someonehelp me to create code for it

Thank you in advance

------------------------------
Rohini Patil
Member technical
ADP
Asia/Kolkata
------------------------------

[shashank.kumar280]

Hi Rohini,

Have you already tried if the MS Excel Extended available on DX can be used for this? It has pivot related actions available in it. https://digitalexchange.blueprism.com/dx/entry/9648/solution/ms-excel-vbo---extended

------------------------------
Shashank Kumar
DX Integrations Partner Consultant
Blue Prism
Singapore
+6581326707
------------------------------

[RohiniPatil1]

​Thank you for your quick response.

Yes, I am able to edit pivot table by using MS Excel Extended VBO.

Note: it shows lots of error because of arrangement of stages 🙂

------------------------------
Rohini Patil
Member technical
ADP
Asia/Kolkata
------------------------------

[shashank.kumar280]

Hi Rohini,

I guess you are referring to the issue where the stages of a Blue Prism Process or Object are stacked on top of each other. If you are on BP v6.5 or earlier, you can fix the display issue by using this asset on DX https://digitalexchange.blueprism.com/dx/entry/9648/solution/blue-prism-studio-display-fix

------------------------------
Shashank Kumar
DX Integrations Partner Consultant
Blue Prism
Singapore
+6581326707
------------------------------