Creating Pivot from a report

thetnaingsoe

New Member
Joined
Nov 7, 2018
Messages
3
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/1r9B0lvyAaTSK5We2nE27aOdBL6rY8SfD/view?usp=sharing

Thanks all in advance

Also posted here
https://www.excelforum.com/excel-ch...creating-pivot-from-a-report.html#post5198041
 
Last edited by a moderator:

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

thetnaingsoe

New Member
Joined
Nov 7, 2018
Messages
3
Just checking in to see if anyone got a chance to look at this and find a way out?


Please help.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,530
Messages
5,596,699
Members
414,088
Latest member
rodriboraun

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top