thetnaingsoe
New Member
- Joined
- Nov 7, 2018
- Messages
- 7
- Office Version
- 365
- Platform
- Windows
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
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:
