Pivot Table in Studio

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)

Hi, I am trying to recreate this on Studio not Studio X


The Activity exists in regular Studio, too.

For mine, I have different specifications as shown in the excel worksheet I provided to find those sum amounts so that activity won’t help for it.

Is there any way you can help me with this?