topic Add field in Pivot Table in Product Forum

Add field in Pivot Table

RohiniPatil1 — Thu, 22 Oct 2020 14:38:00 GMT

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
------------------------------

RE: Add field in Pivot Table

shashank.kumar280 — Thu, 22 Oct 2020 15:25:00 GMT

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
------------------------------

RE: Add field in Pivot Table

RohiniPatil1 — Fri, 23 Oct 2020 07:35:00 GMT

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
------------------------------

RE: Add field in Pivot Table

shashank.kumar280 — Fri, 23 Oct 2020 08:54:00 GMT

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
------------------------------