Pivot Table with In/Out Dates

happyhungarian

Board Regular
Joined
Jul 19, 2011
Messages
226
Office Version
  1. 365
Platform
  1. Windows
Hi, I have a data set with a massive amount of data that changes constantly. I need a pivot table that would show the value of a part number over time as it gets assigned to different projects. Maybe it's just a matter of structuring the data a little differently and doing a special pivot table but I can't figure out how to do it. It also needs to be a pivot table because new project names and part numbers are constantly being created. Is this possible?! I've attached a simple example of what I need it to do.

Thank you Mr. Excel Community!
 

Attachments

  • Example.png
    Example.png
    17.4 KB · Views: 8

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

etaf

Well-known Member
Joined
Oct 24, 2012
Messages
4,659
Office Version
  1. 365
Platform
  1. MacOS
you need to put the date in the columns section
then right click
field settings
Show items with no data
I have filtered to not show < date or > date - BUT this will mean any refresh will need the filter rechecked for any new dates


Maynot be what you want as you are trying to fill ALL the months with a value , but if tht value is constantly changing , how will you know what to assign


Book4
ABCDEFGHIJKLMNOPQRS
1datevalueColumn Labels
21/1/191JanFebMarAprMayJunJulAugSepOctNovDecGrand Total
34/1/192
4Sum of value123
5
Sheet1
 

Watch MrExcel Video

Forum statistics

Threads
1,129,363
Messages
5,635,836
Members
416,885
Latest member
hs11

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