Creating Pivot from a report

Hey guys

I am having a roadblock in creating a pivot to analyse the data.

I have a report in the "Details" tab and calculations are done within the tab.
For example, I have a total cost for a line item by month (from column U to column CZ) and the cost is then allocated to different departments based on the allocation percentage from column O to column C. Each department cost are spread across from column DB to column TI.

I want to create a pivot table to analyse the cost in the following way:
By Account, by Vendor, by Department and by Department.

The reason why I want to create a pivot table is that whenever I want to change the way for analysis purpose, I could easily choose do it. And what I know is that only pivot table could do it.

I tried to write sumproduct forumula in summary tab (it’s now blank) and the result is painful because of the following reasons:
(1) Due to large set of data, the excel is so slow when I add new line item in the "Details" tab.
(2) Whenever I add a new line item in the "Details" tab, I need to update in the Summary tab.
(3) When I want to change the way I want to analayse the data, it’s very inflexible to do so.

Can anyone help me on how to create a pivot table from the report?

As report is exceeding the size limit, it's uploaded here.

https://drive.google.com/file/d/1r9B...ew?usp=sharing

Thanks all in advance

Wow informative post.

I tried to delete most of the data in the file to reduce the file size. It's attached here.

Thanks all

The same question is also posted on this site

https://www.mrexcel.com/forum/excel-...ml#post5345348

Thanks all

Just checking in to see if anyone got a chance to look at this and find a way out?

Please help.