Excel Pivot Creation

Has anyone tried creating a pivot in excel? I keep getting an error executing switchwindowaction when I switch to the window CreatePivotTable (I have already opened the Excel spreadsheet function). Do I need to use the window launch excel function even though I used the open excel function?

Any other thoughts on how to subtotal data using variables? I am trying to subtotal invoice amounts for each invoice number and have multiple invoice rows for each invoice number.


you cannot mix buit-in recorder Excel actions with Mouse clicks, and Keyboard actions. See https://kb.workfusion.com/display/RPAe/Excel