Ok I'm really bad with Microsoft Excel. I am trying to create a pivot table to analyze a group of aircraft and determine whether or not they've had their proper scheduled maintenance checks based on their date of manufacture. For those of you who are familiar with pivot tables, can you please help me? These are the fields I need to include (i just don't know where to put what):
MSN (Manufacturer Serial Number)
DOM (Date of Manufacture)
Aircraft Type (Boeing or Airbus)
SV (Shop Visit...Boeings go for 8, 10 and 12 year checks..while Airbus only has a 6 and 12 year visit
I already have a nicely formatted worksheet...I just need to make the pivot table that shows which aircraft have had their visits and which are overdue and for what kind of check.
I know you're not getting paid to do my job, but I figure lots of you guys are way smarter than I am, so it shouldn't take a whole lot of time/brainpower for one of youse.
Thanks in advance!!
MSN (Manufacturer Serial Number)
DOM (Date of Manufacture)
Aircraft Type (Boeing or Airbus)
SV (Shop Visit...Boeings go for 8, 10 and 12 year checks..while Airbus only has a 6 and 12 year visit
I already have a nicely formatted worksheet...I just need to make the pivot table that shows which aircraft have had their visits and which are overdue and for what kind of check.
I know you're not getting paid to do my job, but I figure lots of you guys are way smarter than I am, so it shouldn't take a whole lot of time/brainpower for one of youse.
Thanks in advance!!