How to convert a table to pivot table with sum of a particular column


#1

I have an excel file having date, department and amount spent by each department. I want to create a pivot table such that it has the sum of amount spent by each individual department and the total too. I have attached a sample file for clarity.Pivot Sample.xlsx (9.8 KB)


#2

@jamnanin
You can group by based on DepartMent column.
For grouping and take the sum refer this post


creating new datatable after grouping and taking sum of each group.
Now to take the sum of that particular column refer the below post

Regards,
Mahesh


#3

Sure! Thanks


#4

Hi @jamnanin,
Take a look the below link. Can use single activity to do the group by

Regards
Balamurugan


#5

Hello All,
I have build lots of Excel & PDF Activities which we use on a daily routine.
Activities are as follows : -

  1. Pivot Table - Works with or without Excel Application Scope.
  2. Filter Range / Data - Works with or without Excel Application Scope.
  3. Find & Replace - Advanced Technology. (See the video)
  4. Text to Columns - Fixed width & Delimiter.
  5. Copy paste data - To same workbook or to other workbook without any format loss.
  6. Remove Duplicates - Single / multiple columns.
  7. Update Status in an Excel sheet after processing some invoices or any (Completed, Success, Closed, etc)
  8. Clear contents - To delete / clear the data of a given column.(See the function lists in drop-down)
  9. Excel Save as - To save the excel in different format (.xls to .xlsb OR .xlsm to .xls)
  10. Cells Formatting - To set the columns in a required format (General, Text, Number or any custom format)
  11. Export PDF to Excel.
  12. Export Notepad to Excel.
  13. Extract specific lines from Notepad and paste into an Excel.
  14. Extract specific lines from PDF and paste into an Excel.

All activites under custom activities in : - https://uipath.devpost.com/submissions
Kindly go through each of the activities…