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)
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