How do I recreate the pivot table in this excel worksheet using UiPath Studio. The pivot table uses the data in the “Report(org)” sheet and finds the Sum of Allocated Expense Amount and the Sum of Total Expense Amount (reimbursement currency).
Do not worry about the columns after “Sum of Total Expense Amount (reimbursement currency)”. Only look at columns A through L on the “Pivot Table” Sheet
Also don’t worry about the “lookup” sheet
template 2020.11.12.xlsx (156.6 KB)