pivot table

  1. T

    Dynamically change part of code in Code stage

    Hi, I have a Code stage that creates Pivot Table in Excel. The first part of the code is general and the second part is there to describe how the Pivot Table should look like. I would like to be able to dynamically change the second part whenever I want to change the Pivot Table layout. How to...
    • to_mas_re
    • Thread
    • code stage dynamic dynamic attributes dynamic values excel pivot table
    • Replies: 4
    • Forum: Blue Prism
  2. B

    Need Help! Filtering PivotTable Error HRESULT: 0x80070057 (E_INVALIDARG))

    sample pivot.jpg - PivotTable sample pivot2.jpg - object input sample pivot3.jpg - code I've been working on this object for a week now and still cant get it right. All lines are working just fine except for the last line where it should filter the pivot field "Month" into the current month...
  3. S

    Excel VBO - Pivot Table Report Layout

    Hello, I'm trying to arrange my pivot table's report layout as tabular form. In the offical document of Microsoft Excel, the related code for changing report layout is: pvt.RowAxisLayout xlTabularRow I wrote this code in Blue Prism as: PvtTbl.RowAxisLayout = "xlTabularRow" Also...
Top