Questions about Pivot Table

noise003

New Member
Joined
Jul 8, 2020
Messages
1
Office Version
  1. 2016
Platform
  1. Windows
Hello everyone!

I work in a Procurement Department and there is one database where the following columns are stated

PR Number (i.e. 1,2,3 etc), Description of Goods/Services, Department, Estimated Budget, Actual Cost.

The question i have is the following

I have transformed this into a pivot table but many times one PR (i.e. Cleaning Services) is divided into 2 or 3 sub-rows (i.e. Cleaning Services Store 1, Store 2 etc). I would like the Pivot Table not to show the amount of the Estimated Budget of the main row (i.e. Cleaning Services) but only the sub-rows (i.e. Cleaning Services Store 1, Store 2 etc) since these are the lines where i fill in the Actual Cost.

The second question is, i would like from this pivot table to insert a column chart where there will be only 2 columns (Total Estimated Budget & Total Actual Cost) and not the costs per department.
 

Some videos you may like

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

pbornemeier

Well-known Member
Joined
May 24, 2005
Messages
3,889
Welcome to the Forum!
Use the XL2BB addon to post a dozen or so rows from your source data so what you are talking about will be more clear.
Another to show how the data in that part of the PivotTable is placed into the table in the second question
If there is some way to identify when the main row has sub-rows?
 

Watch MrExcel Video

Forum statistics

Threads
1,127,556
Messages
5,625,496
Members
416,112
Latest member
somenka

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