Howardc,

Are you asking how to create the existing pivot table in the attached workbook? from what I see, that's different from what you've mentioned
set up a Pivot table to show the total Cost & NBV (New Book Value) per asset type for the 2012 Financial Year (Oct 2011 - Sept 2012)